App Store Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Updating Power BI Connection Configuration ======

The Intelligent Plant - Industrial Connector for Power BI allows report developers to connect to on-prem data source via the Industrial App Store. This is done via **App Store Connect** - a software service that runs within an organization business network to connect internal data sources to online apps such as Power BI. 

A single App Store Connect may host multiple data sources. The example below shows the data sources available on the Intelligent Plant "Demo Data Sources - IPAppStoreNode" App Store Connection.

{{ :power_bi_connector:powerbi-queryconfig-01.png?800 |}}

Data points belonging to a data source can then be queried by tag names.

{{ :power_bi_connector:powerbi-queryconfig-03.png?400 |}}

A change in the name of an App Store Connection, a data source and/or a tag, will require updates to be made to the Power BI report.

===== Where to make changes =====

1. Open the PowerBI Report

2. Select Transform Data > Transform Data

{{ :power_bi_connector:powerbi-queryconfig-04.png?600 |}}

3. For each query, select Advanced Editor

{{ :power_bi_connector:powerbi-queryconfig-05.png?300 |}}

4. Update the query as required...

4.1. A Connection Name will appear 3 times in the query

{{ :power_bi_connector:powerbi-queryconfig-06.png?800 |}}

4.2. The data source name appears alongside the connection name:

{{ :power_bi_connector:powerbi-queryconfig-07.png?800 |}}

4.3. The query will contain 1 or more tags.

{{ :power_bi_connector:powerbi-queryconfig-08.png?800 |}}

5. Save and refresh the report.