Microsoft Power BI

Datalogz supports the latest Metadata API integration with Power BI, which allows you to integrate Power BI assets into your Datalogz environment.

Setting Up Power BI In Datalogz

You can set up a PowerBI integration between Datalogz and your O365 environment in four easy steps.

STEP 1: Create a new Datalogz account using a Microsoft 365 admin account.

  1. Login to Datalogz as a Microsoft 365 admin.

  2. Approve the SAML authentication for your organization’s users to log in using their respective Microsoft accounts (see Appendix i).

  3. Create a Workspace for your organization’s Datalogz environment.

STEP 2: Add the Power BI Connector and approve Power BI API permissions.

  1. In the top menu of the Datalogz homepage, click the blue button New and select Data Source.

  2. Select PowerBI and approve the PowerBI API permissions for your connector. This step must be completed by a M365 Admin, or a user approved to create App Registrations in the Azure Portal.

  3. Before refreshing the connector, complete STEP 3.

STEP 3: Enable API settings for metadata scanning in Power BI admin portal.

  1. Login to https://app.powerbi.com as a Power BI service admin.

  2. Navigate to the settings in the upper right, and click Admin Portal.

  3. Under Tenant settings, scroll down to Admin API settings and enable the following:

    • API responses with detailed metadata

    • API responses with DAX and mashup expressions

    (See Appendix iii for more detail)

STEP 4: Login to Datalogz to refresh the data.

  1. Log in Datalogz using your Microsoft account.

  2. Navigate to Manage Data Sources and select PowerBI connector created in STEP 2.

  3. Refresh the connector and data will be loaded into your enviornment.

🎉 Your Power BI reports and/or dashboards are now connected to your Datalogz account.

How does Datalogz Power BI work?

Datalogz connects to the Power BI via OAuth2.0 flow. Datalogz uses Admin - WorkspaceInfo GetScanResult API to scan the workspace and get the desired data.

What permissions are required?

​​Tenant.Read.All

Can you scan multiple workplaces at one time?

Yes, Admin - WorkspaceInfo GetScanResult API can scan multiple workspaces at one time. It scans the workspaces in the background and Datalogz can query to see the status of the scan. Once the scan is completed, Datalogz will retrieve your PowerBI data.

What workplaces are scanned?

All workspaces can be scanned. Option to exclude personal workspaces exists.

What information is extracted?

Dashboard

  1. Display name

  2. URL

  3. Sensitivity Label

  4. Tiles

  5. Owner

Dataflow

  1. The owner (configured by)

  2. datasourceUsages

  3. Description

  4. Modified DateTime

  5. Name

  6. Upstream data flows

Dataset

  1. Description

  2. Name Tables (issue)

  3. Columns (issue)

  4. Web URL

Datasource

(Tables are mapped back to the underlying source using this API)

  1. Data source type

  2. Name

Measure (Custom SQL)

  1. Description

  2. Expression

  3. formatString

  4. name

Report

  1. Created by

  2. Created DateTime

  3. Description

  4. Embed Url

  5. Modified DateTime

  6. Name

What are considerations and limitations on Admin - WorkspaceInfo GetScanResult API?

Refer to Considerations and limitations to see the limitations on Scan API.

Appendix I

SAML authentication permissions and new workspace creation:

Appendix II

Power BI API Connector permissions:

Appendix III

PreviousVisualization ToolsNextTableau (Coming Soon)

Last updated