Retrieve data views with Power BI Connector

Use CONNECT data services Power BI Connector to retrieve data views for use in Microsoft Power BI.

Prerequisites

While retrieving a data view from CONNECT data services, Power BI Connector prompts you to authenticate with Microsoft Power BI. You have two options for authentication:

• Organizational account

  Authenticate the connection between CONNECT data services and Microsoft Power BI using the same organizational account that you use to sign into CONNECT. If you use this authentication option, Power BI Connector prompts you to reauthenticate the connection every seven days.

  If you choose this authentication option, you can begin the task below without completing any prerequisites.

• Client-credential client

  Use a CONNECT client-credential client Id and client secret to authenticate with Microsoft Power BI. This authentication option is preferred over organizational account because it allows Microsoft Power BI to remain securely connected with CONNECT data services without prompting you to reauthenticate every seven days.

  If you choose this option, you must create and configure a client-credential client for use during authentication. These credentials are used while completing the task below. For instructions on creating these credentials, see Add a client-credentials client. While creating the credentials, select one or more Tenant Roles that provide access to the data view, applying the concept of LeastPrivilege. While creating the credentials, record the Client Id and Client Secret to enter while retrieving a data view.

To retrieve data views

1. In Microsoft Power BI Desktop, in the entry field of the Get Data window, type connect.

   The CONNECT data services (Custom) connector file displays in the All pane.

   

2. Select the CONNECT data services (Custom) connector file, and then select Connect.

3. Select Continue in the Connecting to a third-party service warning.

4. In the CONNECT data services window, enter the namespace for the data views you want to access, and then select OK.

5. Authenticate the connection between CONNECT data services and Microsoft Power BI.

   • Organizational Account:

     Select Organizational account. Then select Log in. Enter the credentials you use to sign in with CONNECT.

   • Client Credentials:

     Select Client Credentials. Then enter the ClientId and the Client Secret for the client credential clients that you created while fulfilling the prerequisites.

6. Select Connect to connect CONNECT data services to Microsoft Power BI.

7. In the Navigator pane, choose a data view to work with from either Interpolated Data Views or Stored Data Views.

   

8. Specify a Start Index and End Index for the data that you want to work with. Enter the date in YYYY-MM-DDTHH:mm:ss format.

9. If you are working with an Interpolated Data Views, you must specify an Interpolation Interval as well. Enter it in dd.hh:mm:ss format.

10. If a data view you are working with has default index values or default interpolation interval values defined, you can override them by entering new values and selecting Apply.

    

11. Select Load at the bottom of the Navigator pane to load all selected data views to Microsoft Power BI.

12. (Optional) If you are using an on-premises data gateway in combination with the Client Credentials authentication method, we recommend creating a new data source connection within the Power BI Service that uses your client credentials for authentication.

13. For more information on creating a data source connection in the Power BI Service, see the Microsoft document Add or remove a gateway data source. The client credentials authentication method is recommended when using the CONNECT data services Power BI Connector as a data source in the Power BI Service.