Home Service Blog Contact About

Home Service Blog Contact About

Power BI Admin API [1/3]

While Power BI offers build in data lineage views and performance metrics, it will not give you a holistic overview. Microsoft announced new options using Azure Log Analytics or Azure Purview, but this will require additional Azure subscriptions and might not give you all the required information. A great alternative is to use the Power BI REST APIs with a service principal and schedule the calls without requiring a manual log-in. In the following post you will learn how to implement a connection to the Admin APIs with PowerShell. 

04.01.2021

Power BI Admin API [2/3]

In this post we will use PowerShell scripts to extract the artifacts (Power BI workspaces, dataflows, datasets, reports and dashboards) as well licensing information, refreshables and data sources. In addition different storage options and the implementation in PowerShell are being discussed. As a result you will learn how to work with the Power BI API and you are able to customize the scripts to your needs. 

04.01.2021

Power BI Admin API [3/3]

The creation of a Power BI dataset on top of the extracted Power BI Admin API json files is described here. This includes the extract, transform and load process as well as the creation of the relationship between the different tables and the creation of DAX measures. In the end possible visualization techniques are presented.  

04.02.2021