Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. To use the Power BI Writeback connector, you need an installed Microsoft Azure app. To learn more about the Power BI API, visit their page (https://docs.microsoft.com/en-us/rest/api/power-bi/).
You configure your Domo-Sharepoint connection in the Data Center. This topic discusses the fields and menus that are specific to the Power BI Writeback connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
To configure this connector, you must have the following:
An installed Microsoft Azure app.
The Client ID and Client Secret for your Azure app.
The Tenant ID for your Azure app. This is generated when you create your Azure app.
The username and password for your Azure Active Directory.
To obtain the Azure App Client ID:
1. Go to https://portal.azure.com.
2. Select Azure Active Directory > App registrations.
3. Find and click on your web app.
4. The "application ID" is your Client ID.
To obtain a new Azure App Client secret:
Go to https://portal.azure.com.
Select Azure Active Directory > App registrations.
Find and click on your web app.
Open Certificates and secrets.
Click +New client secret.
Provide the client secret description and the expiry period for your secret. Click Add.
Your new client secret will appear. Copy it and paste in your Domo connector Client Secret field.
To obtain the Tenant ID:
- Login to the Azure Portal (https://protal.azure.com).
- Navigate to Azure Active Directory >> Properties.
- Copy the Directory ID. The directory ID is your Tenant ID.
Creating an Azure App for Enterprise OAuth
To create a Microsoft Azure app, do the following:
1. Log into https://portal.azure.com.
2. Click on App registrations.
3. Click New registration.
4. Enter the application name and select the supported account type as below. Enter the Redirect URI for Web as https://oauth.domo.com/api/data/v1/oauth/providers/power-bi-writeback/exchange.
5. Click Register. Once the application is registered, you can view the Client ID (application ID), client secret, and tenant ID.
Configuring the Connection
This section enumerates the options in the Credentials and Details panes in the Power BI Writeback Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most Connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
This pane contains fields for entering credentials to connect to your Power BI account. The following table describes what is needed for each field:
|Azure Application Client ID||Enter the client ID (GUID) of the client web app obtained from Azure Active Directory configuration. For more information, see "Obtaining the Azure App Client ID".|
|Azure Application Client Secret||Enter the secret key of the client web app. For more information, see "Obtaining the Azure App Client Secret".|
|Azure Tenant ID||Enter your Tenant ID. For more information, see "Obtaining the Tenant ID".|
|Username||Enter your Azure Active Directory username.|
|Password||Enter your Azure Active Directory password.|
For more information about obtaining these credentials, see Prerequisites, above.
Once you have entered valid Power BI credentials, you can use the same account any time you go to set up a new new Domo-Power BI connection. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
This pane contains a number of fields for specifying your data and indicating where it's going.
Input DataSet ID
Enter the DataSet ID (GUID) for the DataSet you want to copy to Sharepoint Online. You can find the ID by opening the details view for the DataSet in the Data Center and looking at the portion of the URL following datasources/. For example, in the URL https://mycompany.domo.com/datasources/845305d8-da3d-4107-a9d6-13ef3f86d4a4/details/overview, the DataSet ID is 845305d8-da3d-4107-a9d6-13ef3f86d4a4.
|Select Group||Select the group.|
|Enter Dataset Name||Enter the dataset name.|
|Enter Table Name||Enter the table name.|
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.
- Make sure your authentication remains valid.
- Review the configuration to make sure that all required items have been selected.
- Review the Connector history for error messages.
- In rare cases, you may be requesting too much information and reaching API limitations or timeouts. If this is the case, you can review the history of the Connector run to see the error message and duration. If this is the case, you can reduce the number of accounts that are being pulled, choose a smaller number of metrics for the report that you are pulling, or reduce the timeframe that you are trying to pull.