User Tools

Site Tools


power_bi_connector:getting_started

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
power_bi_connector:getting_started [2023/11/03 11:33] – [Getting the connector] supower_bi_connector:getting_started [2024/01/31 14:17] (current) su
Line 5: Line 5:
  
  
-===== What is the Power BI Connector? =====+===== What is the Industrial Connector for Power BI? =====
  
-The Power BI Connector solves a common industry problem - getting operational data into Power BI. +The Industrial Connector solves a common industry problem - getting operational data into Power BI. 
  
 Historian data does not come in the tabular format that Power BI desires. Our connector completes this essential task in a way that requires no complicated queries, no secondary data storage location, and no SQL - We connect straight from your historian with our data connectivity software, [[app_store_connect:app_store_connect|App Store Connect]].  Historian data does not come in the tabular format that Power BI desires. Our connector completes this essential task in a way that requires no complicated queries, no secondary data storage location, and no SQL - We connect straight from your historian with our data connectivity software, [[app_store_connect:app_store_connect|App Store Connect]]. 
  
-Users commonly use our Power BI Connector to import process data. However, you can also import Alarm & Event data, along with.[[https://github.com/intelligentplant/IAS-Power-BI-connector#using-alarm--event-meta-tags-alarm_clock|calculated alarm KPIs]]+Users commonly use our Industrial Connector to import process data. However, you can also import Alarm & Event data, along with.[[https://github.com/intelligentplant/IAS-Power-BI-connector#using-alarm--event-meta-tags-alarm_clock|calculated alarm KPIs]]
  
 ---- ----
  
-===== Getting the connector =====+===== Getting the Industrial Connector =====
  
-Intelligent Plant's Industrial App Store Power BI Connector is Microsoft Certified and distributed with Power BI Desktop as of the [[https://powerbi.microsoft.com/en-us/blog/tag/intelligent-plants-industrial-app-store/|(May 2019)]] update. +Intelligent Plant's Industrial Connector for Power BI is Microsoft Certified and distributed with Power BI Desktop as of the [[https://powerbi.microsoft.com/en-us/blog/tag/intelligent-plants-industrial-app-store/|(May 2019)]] update. 
  
 {{ :power_bi_connector:power-bi-solution-overview-approach.png?nolink&750 | Solution Overview/Approach}} {{ :power_bi_connector:power-bi-solution-overview-approach.png?nolink&750 | Solution Overview/Approach}}
Line 23: Line 23:
 ---- ----
  
-===== Connect to your data =====+===== How to Access the Industrial Connector and Connect to your data =====
  
-  - Open Power BI Desktop. +Intelligent Plant's Industrial Connector is accessible via Power BI Desktop. 
-  - Click "Get Data" on the Home tab and search for "Industrial App Store". + 
-  - Sign in to the Industrial App Store using either service provided+If your organisation already has a license for the Industrial Connector, follow the steps below on how to access it, or watch our [[https://www.youtube.com/watch?v=b0c59MeByRU|video walkthrough]] 
-  - Select the data source you would like to query+ 
-  - Use the "Tag Search" function to perform tag searches"Get Processed" function to get data from your data source in a variety of aggregationsand "Get Plot" function, designed specifically for visualising your operational data+Before going through the steps, please make sure you have Power BI Desktop installed. You can download it via [[https://powerbi.microsoft.com/en-gb/downloads/|Microsoft's official website]] 
-  - Enter your tag name(s), start date, end date, function and interval/point count+ 
-  - Click "Loadto import the queried dataset into the dashboard.+  - Open up Power BI Desktop. 
 +  - On the Home tab, select "Get Data". 
 +  - Enter in "Industrial App Store" and click "Connect"
 +  - Click "Sign In". The App Authorization page will pop up (if you have used and authorized the connector before, you may not see this window. Skip to step 7.) 
 +  - Select which data sources you wish to use on Power BI Desktop by clicking on them. When selectedthey will turn green. Note - If you do not see the data source you needplease contact your Administrator
 +  - Scroll to the bottom of the App Authorization page and click "I agree - sign me into Power BI Connector"
 +  - Click "Connectand the Navigator window will open within Power BI. 
 +  - You can begin entering in your query. Details on how to create a query can be found further down on this page. Alternatively, our video walkthrough provides explanation.
  
 {{ :power_bi_connector:ias-connector-01.png?600 | Connect to your data}} {{ :power_bi_connector:ias-connector-01.png?600 | Connect to your data}}
Line 40: Line 47:
 ===== Video Walkthrough ===== ===== Video Walkthrough =====
  
-For more information, you can check our [[https://youtu.be/b0c59MeByRU?si=ikmEQ7iJ5Q1s5d1s | Power BI Connector YouTube walkthrough]]. +For more information, you can check our [[https://youtu.be/b0c59MeByRU?si=ikmEQ7iJ5Q1s5d1s | Industrial Connector YouTube walkthrough]].
- +
-**Please note, the connector has received updates since the creation of this video - the configuration will look different now, however it remains fundamentally similar. **+
  
 Feel free to [[https://www.intelligentplant.com/contact.html | get in touch with us]] if you need assistance setting up the connector or if you have any questions. Feel free to [[https://www.intelligentplant.com/contact.html | get in touch with us]] if you need assistance setting up the connector or if you have any questions.
Line 50: Line 55:
 ===== Licensing ===== ===== Licensing =====
  
-Customers need to purchase a subscription in order to retrieve data using Industrial App Store (IAS) Connector. Please[[https://www.intelligentplant.com/contactus|contact Intelligent Plant]] or ping us an email at info@intelligentplant.com if you have questions.+Customers need to purchase a subscription in order to retrieve data using the Industrial Connector. Please[[https://www.intelligentplant.com/contactus|contact Intelligent Plant]] or ping us an email at info@intelligentplant.com if you have questions.
  
-  * An unlicensed data response in IAS Connector will look like this:+  * An unlicensed data response in Industrial Connector will look like this:
 {{ :power_bi_connector:unlicensed_request_-_full.png?nolink&800 | Unlicensed request - full}} {{ :power_bi_connector:unlicensed_request_-_full.png?nolink&800 | Unlicensed request - full}}
  
power_bi_connector/getting_started.1699011182.txt.gz · Last modified: 2023/11/03 11:33 by su