Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from Microsoft Azure Power BI Service (Repository)

Bridge Specifications

Vendor Microsoft
Tool Name Azure Power BI
Tool Version 2.x
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

BRIDGE INFORMATION
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.1.0

BRIDGE DISCLAIMER
This bridge requires internet access to https://repo.maven.apache.org/maven2/ (and exceptionally a few other tool sites)
in order to download the necessary third party software libraries into $HOME/data/download/MIMB/
(such directory can be copied from another MIMB server with internet access).
By running this bridge, you hereby acknowledge responsibility for the license terms and any potential security vulnerabilities from these downloaded third party software libraries.

BRIDGE DOCUMENTATION
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:
https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-integrating-applications

Alternatively, it is possible to register the application with Azure Active Directory using this page:
https://dev.powerbi.com/apps
Note that it may be necessary to grant consent for the specified permissions using the Azure management console.

KNOWN LIMITATIONS

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.


Bridge Parameters

Parameter Name Description Type Values Default Scope
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).
STRING      

 

Bridge Mapping

Mapping information is not available

Last updated on Fri, 17 May 2019 17:36:20

Copyright © Meta Integration Technology, Inc. 1997-2019 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.