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

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.
- At the bottom of the page, add permission to the Power BI Service application, and enable necessary permissions.
- At the bottom of the page, click on the save button.
The bridge will use the Client 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

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, 21 Sep 2018 16:15:06

Copyright © Meta Integration Technology, Inc. 1997-2018 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.