Transitioning to Fabric requires adjusting the ways we get information about the activities taking place in Fabric environments.
The traditional way we used to set up Power BI Environment Governance Reports was to use Power Shell scripts to call the Power BI REST API using Azure Functions Apps.
Tagging along with the idea of Fabric, we thought that it would be of a great value to have everything in one place i.e. Fabric environment as opposed to having the bits and pieces behind the Governance Reports in different places.
Our project shows how to rework existing Power Shell scripts using Azure Open AI into Python scripts in order to create a Fabric Governance Report. The Python scripts created as a result of our project can be easily reused and adjusted allowing you to set up your own Fabric Activity Cockpit in practically no time. The only thing to keep in mind here that all the passwords and secrets have to still be kept in Azure Environment as you dont wanna disclose them.
Other that that, the solution offers you a notebook with python scripst which gets triggered by the data piplines that allow you to store your data retrieved from the Fabric API into a lakehouse. Following that, based on your set up, you can either create a dataflow with the adjustments to the quieries retrieved and publish them into gold layer or you can create a report based on the default semantic model. (Remark: Beware, different versions of Power BI bear various isssues and give you quite a different experience)
Our project allows you to have a smooth transition to a one-stop-shop idea driving the adoption of Microsoft Fabric.
Project name
Fabric Activity Cockpit
Description
Transitioning to Fabric requires adjusting the ways we get information about the activities taking place in Fabric environments. The traditional way we used to set up Power BI Environment Governance Reports was to use Power Shell scripts to call the Power BI REST API using Azure Functions Apps.
Tagging along with the idea of Fabric, we thought that it would be of a great value to have everything in one place i.e. Fabric environment as opposed to having the bits and pieces behind the Governance Reports in different places.
Our project shows how to rework existing Power Shell scripts using Azure Open AI into Python scripts in order to create a Fabric Governance Report. The Python scripts created as a result of our project can be easily reused and adjusted allowing you to set up your own Fabric Activity Cockpit in practically no time. The only thing to keep in mind here that all the passwords and secrets have to still be kept in Azure Environment as you dont wanna disclose them.
Other that that, the solution offers you a notebook with python scripst which gets triggered by the data piplines that allow you to store your data retrieved from the Fabric API into a lakehouse. Following that, based on your set up, you can either create a dataflow with the adjustments to the quieries retrieved and publish them into gold layer or you can create a report based on the default semantic model. (Remark: Beware, different versions of Power BI bear various isssues and give you quite a different experience)
Our project allows you to have a smooth transition to a one-stop-shop idea driving the adoption of Microsoft Fabric.
Project Repository URL
https://github.com/AllgeierSchweiz/fabric-ai-hack-activity-cockpit/tree/main
Project video
https://allgeierschweiz-my.sharepoint.com/:v:/g/personal/odontsova_allgeier_ch/EUgQC1GRsg5CkVG-wgAGq9cBSl0l0G600oeAoYxOkRyDxA?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJPbmVEcml2ZUZvckJ1c2luZXNzIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXciLCJyZWZlcnJhbFZpZXciOiJNeUZpbGVzTGlua0NvcHkifX0&e=CMJAhH
Team members
Olga Dontsova, Nicolas Rehder