Configure the DataMosaix Power BI Connector

Configure the DataMosaix Power BI Connector

Perform the following steps to configure the DataMosaix Power BI connector:
  1. Download the connector file (DataMosaix.mez) using this link if you have not done already.
  2. Copy the connector file (DataMosaix.mez) to the following location:
    Location Details
    Users
    Location
    Power BI Gateway Personal Mode
    C:\Users\<username>\Documents\Power BI Desktop\Custom Connectors
    Power BI Gateway Standard Mode
    C:\Users\Public\Documents\Power BI Desktop\Custom Connectors
  3. Go to Power BI Desktop
    Options
     >
    Security
     >
    Data Extensions
    , and verify that the second option is selected, or else select it.
    Verify Option
  4. Re-open the Power BI Desktop.
    Now the custom connectors can be selected on Power BI Desktop.
  5. Register the application using the Single Page Application type in FactoryTalk DataMosaix. For information on registering an application in FactoryTalk DataMosaix, refer to Register Application.
    NOTE:
    For registering Single Page Applications for Power BI, use https://oauth.powerbi.com/views/oauthredirect.html as the application URL (callback URL).
    NOTE:
    Note the generated client ID.
  6. In the Power BI Desktop application, navigate to
    Get Data
     >
    More....
    Navigate to More
    The
    Get Data
     dialog box is displayed.
  7. In the
    Get Data
     dialog box, select
    Other
     >
    FT DataMosaix (Beta)
    .
    Get Data Dialog
  8. Click
    Connect
    .
    The following dialog box is displayed.
    FT DataMosaix Dialog
  9. From the
    Environment
     drop-down list, select the
    prod
     environment. Also provide the
    Application ID
     (Client ID), and
    Project Name
     details, and click
    OK
    .
    Tip: For Application ID, use the Client ID generated while registering the application. Refer to the following screenshot:
    PowerBI Detail
  10. In the
    Authentication
     dialog box, select
    Oauth2
     and then
    Sign in
     to DataMosaix with your credentials. You may need to authenticate if you are connecting to your project for the first time.
    Authentication Dialog
  11. Click
    Connect
    .
    The Power BI Connector connects to the data source and displays the available data sources in the
    Navigator
     dialog box. You are now ready to work with Power BI reports.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.