Microsoft Power BI
Connection Type | Alteryx Tool (available from the Alteryx Community) |
Driver Details | A Microsoft Power BI account must be created. |
Type of Support | Write |
Version | Description |
v3.3.1 |
|
v3.3.0 |
|
v3.2.0 |
|
v3.1.0 |
|
v3.0.0 |
|
v2.1.3 |
|
v2.1.2 |
|
v2.1.1 |
|
v2.1.0 |
|
v2.0.0 |
|
v1.0.0 (deprecated) |
|
Alteryx Tools Used to Connect
Microsoft Power BI Output Tool
See Microsoft's Push datasets limitations for limitations and additional details.
Due to Power BI API limitation, Designer can't write DateTime values. Convert the DateTime values to strings before uploading the dataset to Power BI.
Data Connection Manager
Power BI Output version 3.3.0 and later supports Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to Power BI and easily reuse the stored credentials in workflows that include Power BI Output. Alteryx Server requires stored credentials to successfully run the published workflows.
Enable AMP Engine
Make sure you have the AMP engine enabled for the workflows which contain the Power BI Output tool version 3.3.0 and later.
Custom API Application Setup
For more information on how to build and manage an application using the Microsoft Azure cloud services, refer to the Azure documentation.
-
Go to Microsoft Azure
-
Sign in with your Microsoft Azure Active Directory account.
-
On the Home screen use Search, or go to the upper left corner menu to open the Azure Active Directory service.
-
Open App registrations in the left menu.
-
Select + New registration.
-
Specify the Name of the app.
-
Choose desired account type – both Single-tenant and Multi-tenant are allowed.
-
In the Redirect URI section
-
For Power BI Output version 3.1.0 and earlier: Select Single-page application (SPA) from the dropdown menu and set the two URLs:
-
For Power BI Output version 3.2.0 and later: Select Web-page application (WPA) from the dropdown menu and set the URL:
-
-
Select Register.
The Application (client) ID is your Client ID.
The Directory (tenant) ID is your Tenant ID. -
Now proceed to Certificates & secrets and add New client secret.
Copy the Value as it won't be accessible again once you leave the page–this is your Secret ID. -
Go to API permissions and add these Delegated permissions:
-
Microsoft Graph
-
Offline_access
-
Openid
-
User.Read
-
email
-
profile
-
-
Power BI Service
-
Dataset.ReadWrite.All
-
Workspace.Read.All
-
-
-
To use service principal (app-only authentication) proceed to Certificates & secrets and add New client secret. Copy the Value as it won't be accessible again once you leave the page – this is your Client Secret.
-
To use the custom API application...
- Create an Azure security group and add the Power BI app registration (service principal) to it.
- In the Power BI Admin Portal, go to Tenant Settings > Developer Settings. Turn on the option to Allow service principals to use Power BI APIs and add the security group under Apply to.
- Add the Power BI app registration to your workspace access as a member. For more details, see the Power BI documentation.
Now you can use this app in your Alteryx SharePoint Files connector. To authenticate login, you will need your User Name, Password, Client ID, and Client Secret ID and Tenant ID provided with application registration.
For more information, visit Microsoft portal.