Microsoft Power BI

Version:
2022.1
Last modified: May 04, 2022
Connection Type

Alteryx Tool (available from the Alteryx Community)

Driver Details

Microsoft Power BI account must be created.

Type of Support

Write

Release Notes
Version Description
v3.2.0
  • Authentication occurs using user's browser instead of embedded CEF in Designer to comply with modern security policies like Conditional Access.
  • The login session is valid for 6 months (instead of 24 hours in the previous versions) which is more suitable for scheduling.
  • Compatible with Alteryx Designer version 2021.3.4 and later.
v3.1.0
  • Added option to use Service Principal.

  • Added option to disable SSL validation (not recommended, debugging purposes only).

  • Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.
v3.0.0
  • Built-in multitenant Azure App with an option to use custom Azure App 
  • Supports multiple table inputs 
  • Keeps existing dataset and its structure with updating/overwriting data 
  • User can select which workspace to work with
  • Proxy support 
  • Compatible with Alteryx Designer version 2021.2.2 and later
v2.1.3
  • Removed pre-packaged virtual environment configuration in support of .yxi installer enhancements made for Designer 2020.2.
v2.1.2
  • Add/correct the metadata search tags to both the config.xml in the yxi package and the tool’s configuration xml files.
  • Fix issue with request-oauthlib version conflicts with oathlib version 2.0.6 at runtime.
v2.1.1
  • Tool metainfo update.
v2.1.0
  • Added support for selecting a data set and table from a populated dropdown.
v2.0.0
  • The new YXI Power BI Output Connector with the following improvements from existing macro.
  • Adds support for selecting Power BI workspaces other than “My Workspace”.
  • Updates UX to match other YXI Connectors.
  • Name changed to Power BI Output.
v1.0.0 (deprecated)
  • Initial release.

 

Alteryx tools used to connect

Link
Gray icon with bar graph inside

Microsoft Power BI Output Tool

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.

  1. Go to  Microsoft Azure  

  2. Sign in with your Microsoft Azure Active Directory account. 

  3. On the Home screen use Search, or go to the upper left corner menu to open the Azure Active Directory service.

  4. Open App registrations in the left menu.

  5. Select + New registration.

  6. Specify the Name of the app.

  7. Choose desired account type – both Single-tenant and Multi-tenant are allowed.

  8. In the Redirect URI section

    1. For Power BI Output version 3.1.0 and earlier: Select Single-page application (SPA) from the dropdown menu and set the two URLs

      1.  https://cef.alteryx.com/designer/oauthcallback

      2.  https://login.live.com/oauth20_desktop.srf

    2. For Power BI Output version 3.2.0 and later: Select Web-page application (WPA) from the dropdown menu and set the URL:

  9. Select Register.
    The Application (client) ID is your Client ID.
    The Directory (tenant) ID is your Tenant ID

  10. 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.  

  11. Go to API permissions and add these Delegated permissions

    1. Microsoft Graph

      1. Offline_access  

      2. Openid  

      3. User.Read

      4. email

      5. profile

    2. Power BI Service

      1. Dataset.ReadWrite.All  

      2. Workspace.Read.All

  12. 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.

Now you can use this app in your Alteryx SharePoint Files connector. To authenticate login, you will need your User NamePasswordClient ID, and Client Secret ID and Tenant ID provided with application registration.

For more information, visit Microsoft portal.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.