Power BI

This section describes how to connect to your CDF project using Power BI connector to transform data.
Prerequisites
  • Access to FactoryTalk DataMosaix.
  • Data Scientist role is assigned to create applications in FactoryTalk DataMosaix.
  • Application is registered in FactoryTalk DataMosaix. If you have not registered an application yet, refer to Add Application.
  • Power BI connector application is downloaded from Rockwell Automation provided link or link provided by an authorized representative. Install the application to a desired folder.
Connect to CDF using Power BI Connector
  1. After you install Power BI connector provided by Rockwell Automation, locate the connector file (DataMosaix.mez). If the Power BI connector is installed in the "DataMosaix-PowerBI-Connector" folder the connector file path will be the following: 
    C:\DataMosaix-PowerBI-Connector\DataMosaix\bin\AnyCPU\Debug\DataMosaix.mez
  2. Copy the connector file to the following location: 
    C:\Users\<username>\Documents\Power BI Desktop\Custom Connectors
  3. Start Power BI Desktop.
    You are now ready to connect to data. To see the different data sources available, select
    Get Data
     in the Power BI Desktop
    Home
     tab.
  4. Select
    Get Data > More...
    .
    The
    Get Data
     dialog box displays.
  5. In the
    Get Data
     dialog box, select
    Other > FT DataMosaix (Beta)
    .
  6. Click [Connect].
  7. Provide the CDF project name, client ID and click [OK].
    For client ID, use
    DY8si96fbGNWqUeECxeOEiVMdCmbIyTL
    You must authenticate if you are connecting to your CDF project for the first time.
  8. In the Authentication dialog box, select
    Oauth2
     and then
    Sign in
     with your organizational ID.
  9. Click [Connect]. Power BI Connector connects to the data source and displays the available data sources in the
    Navigator
     dialog box.
You can now select the tables, other data from the data source and transform data with the Power Query Editor.
Troubleshooting
If you have trouble signing in, refer Troubleshoot Power BI Desktop publishing to clear cache and to delete cached permissions.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.