You can integrate with Microsoft Power BI to map the dependencies between Power BI objects and data pipelines.
The search engine has been upgraded accordingly to include all Power BI dashboards in the search.

To connect Sifflet to Power BI, you will need a Power BI account and an Azure Active Directory account, both with admin rights.
This will allow creating a read-only access for Sifflet.

The main steps are the following:

  1. Create an Azure Active Directory App for Sifflet and generate client ID and secret
  2. Configure Power BI to allow Sifflet to communicate with Power BI's API
  3. Add Power BI datasource In Sifflet

1- Create an Azure Active Directory App for Sifflet

In this step, you will create a service principal for Sifflet in your Azure Active Directory. This will enable Sifflet to access Power BI service content and APIs.

You can follow steps 1 and 2 in this official Azure documentation.

2- Configure Sifflet service principal to access Power BI

You can follow steps 3 and 4 in this official Azure documentation.

3- Connect Sifflet to Power BI

Back to your Sifflet tenant:

  1. Create the Power BI secret that Sifflet will use to connect:

    • On the left panel, choose "Integration" and then the "Secrets" submenu

    • Press "New" Secret

    • Information required:

      • Name of your secret

      • The secret is the client secret of the app you previously created in Part 1

        The format on Sifflet is just the secret istelf.

  1. Add the Power BI datasource:

    • On the left panel, choose "Integration" and then the "Sources" submenu

    • Press "New" Datasource

    • Information required:

      • Name of the datasource

      • Power BI Workspace Id: the Power BI Workspace Id can be found directly in the URL link when you are using Power BI.
        For https://app.powerbi.com/groups/037b193e-74f4-4132-96ea-bcda6639f743, the Workspace Id will be 037b193e-74f4-4132-96ea-bcda6639f743

      • Azure AD tenant Id and Azure AD client Id: both can be found on the Overview of your app on Azure

      • Secret: choose the newly created secret