Skip to main content

Load Metadata from Microsoft Power BI On-Premises (Server)

Use the Microsoft Power BI On-Premises Loader to upload metadata to Alteryx Connect from your Microsoft Power BI Server.

Important

After removing the DataMashup file by Microsoft for the newly created Power BI reports, the possibility to create a lineage for new Power BI reports has been lost (for new reports).

Review Loader Requirements

The Alteryx Connect Loaders must be installed on the machine where Alteryx Server is installed. To install the loaders:

  1. Download the loaders installer. For compatibility, the Loaders installer version must match the Alteryx Connect version.

  2. Run the installer as an administrator.

Open the Loader

  1. Open Alteryx Designer.

  2. Select Help >Sample Workflows > Alteryx Connect Metadata Loaders > Power BI OnPremises Loader > Power BI OnPremises Loader.

Run the App

  1. Select Run as Analytic App Run as analytic app button.

  2. In the Power BI Server tab, type the Power BI Server URL and your credentials.

  3. In the Alteryx Connect tab, type the URL for your Alteryx Connect instance and your credentials.

    https://yourcompany.alteryxconnect.com

  4. Before running the app, select Save button and save the app configuration to the following directory:

    C:\ProgramData\Alteryx\AlteryxConnect\PowerBI_OnPremises_Loader\

    The .yxwv app values file is used for scheduling the loader to run in the Gallery. See Schedule Metadata Loaders.

  5. Select Finish to run the app.

    • If the run succeeds, "Success" appears in the App Results window.

    • If the run fails, a "There were Errors" message appears.

    Depending on how much metadata is being imported, the app can take a long time to run.

View the Metadata

  1. Go to the Alteryx Connect URL and log in.

  2. From the main menu, select Data Sources > Power BI Server.

  3. Select a folder to view its contents.

In this section: