Skip to main content

Configuring Your PowerBI Connector to DataHub

Now that you have created a DataHub specific Azure AD app with the relevant access in the prior step, it's now time to set up a connection via the DataHub UI.

Configure Secrets​

  1. Within DataHub, navigate to the Ingestion tab in the top, right corner of your screen

Navigate to the "Ingestion Tab"

note

If you do not see the Ingestion tab, please contact your DataHub admin to grant you the correct permissions

  1. Navigate to the Secrets tab and click Create new secret

Secrets Tab

  1. Create a client id secret

    This will securely store your PowerBI Application (client) ID within DataHub

    • Enter a name like POWER_BI_CLIENT_ID - we will use this later to refer to the Application (client) ID
    • Enter the Application (client) ID
    • Optionally add a description
    • Click Create

Application (client) ID

  1. Create a secret to store Azure AD app secret

    This will securely store your Azure AD app secret

    • Enter a name like POWER_BI_CLIENT_SECRET - we will use this later to refer to the secret
    • Enter the Azure AD app secret
    • Optionally add a description
    • Click Create

Azure AD app Secret

Configure Recipe​

  1. Navigate to the Sources tab and click Create new source

Click "Create new source"

  1. Select PowerBI

Select PowerBI from the options

  1. Fill out the PowerBI Recipe

    Your PowerBI Tenant Id can be found at PowerBI Portal -> Click on `?` at top-right corner -> Click on `About PowerBI`

    Select PowerBI from the options

    On About PowerBI window copy ctid as shown in below screenshot

tenant id

Sample recipe screenshot

tenant id

After you have successfully fill up the recipe, click on Next.

Schedule Execution​

Now it's time to schedule a recurring ingestion pipeline to regularly extract metadata from your PowerBI instance.

  1. Decide how regularly you want this ingestion to run-- day, month, year, hour, minute, etc. Select from the dropdown

schedule selector

  1. Ensure you've configured your correct timezone

    timezone_selector

  2. Click Next when you are done

Finish Up​

  1. Name your ingestion source, then click Save and Run

    Name your ingestion

You will now find your new ingestion source running

ingestion_running

Validate Ingestion Runs​

  1. View the latest status of ingestion runs on the Ingestion page

ingestion succeeded

  1. Click the plus sign to expand the full list of historical runs and outcomes; click Details to see the outcomes of a specific run

ingestion_details

  1. From the Ingestion Run Details page, pick View All to see which entities were ingested

ingestion_details_view_all

  1. Pick an entity from the list to manually validate if it contains the detail you expected

ingestion_details_view_all

Congratulations! You've successfully set up PowerBI as an ingestion source for DataHub!

Need more help? Join the conversation in Slack!