|Tool Name||Azure Power BI|
|Tool Web Site||https://powerbi.microsoft.com/|
|Supported Methodology||[Business Intelligence] Multi-Model, Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model, Stored Procedure Expression Parsing), BI Report (Relational Source, Dimensional Source, Expression Parsing, Report Structure) via Java REST API|
Import tool: Microsoft Azure Power BI 2.x (https://powerbi.microsoft.com/)
Import interface: [Business Intelligence] Multi-Model, Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model, Stored Procedure Expression Parsing), BI Report (Relational Source, Dimensional Source, Expression Parsing, Report Structure) via Java REST API from Microsoft Azure Power BI Service (Repository)
Import bridge: 'MicrosoftAzurePowerBI' 10.0.1
This bridge imports metadata from the Microsoft Power BI service hosted in Microsoft Azure cloud.
When connecting to the Power BI service hosted in Microsoft Azure cloud, the bridge uses Azure ActiveDirectory authentication.
The following Azure configuration steps are required:
- Connect to the Azure management console: https://manage.windowsazure.com
- Create or open the Azure Active Directory which corresponds to your organization.
- On the Applications page, create an application named 'MIMB' of type 'Native Client', and write down its Client ID (Application ID).
- Make sure to add permission to the Power BI Service application, and grant necessary permissions.
The bridge will use the Client ID (Application ID) information to connect to Azure, and obtain the authentication token.
For more details:
Alternatively, it is possible to register the application with Azure Active Directory using this page:
Note that it may be necessary to grant consent for the specified permissions using the Azure management console.
PowerBI supports 6 types of datasets: 'Push', 'Streaming', 'PushStreaming', 'AzureAS', 'AsOnPrem' and dataset from uploaded PBIX files. The structure of datasets (in term of tables and columns) is exposed only for 'Push' and 'PushStreaming' dataset types, due to Api limitations.
The PowerBI PBIX file format currently has no public Sdk or Api to allow inspecting the structure of the report, the tables it contains, and detailed lineage to sources. The PowerBI Rest Api only allow retrieving the name(s) of data connection(s) used by the report. Lineage metadata is only available at the model level or connection level, not at the table or column level.
|Login User||Enter the username which the bridge will use to log in. Be sure this user name has necessary permissions to access the objects you wish to import.||STRING||Administrator||Mandatory|
|Login Password||Enter the password associated with the username which the bridge will use to log in.||PASSWORD|
|Client ID||Enter the Microsoft Azure Client ID for the application.||STRING||Mandatory|
|Miscellaneous||Specify miscellaneous options identified with a -letter and value.
For example, -m 4G
-v set environment variable(s) (e.g. -v var1=value -v var2="value with spaces").
-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
Mapping information is not available