Advocate ISemantic Link - Impact IQ, Visual-Level Lineage and Impact Analysis
Have you ever renamed a measure or column in your model, only to realize it’s used in reports....and suddenly you’re getting flooded with emails about broken visuals? Or wanted to delete a measure or change its logic, but had no clear view of where it’s being used across workspaces and reports?
Impact IQ - Semantic Link Labs Edition provides a quick and automated way to identify where and how specific fields, measures, and tables are used in your Power BI reports....across all workspaces....by analyzing the Report Layer in tandem with the connected model. It also breaks down the details of your models, reports, and dataflows for easy review, giving you an all-in-one Power BI & Fabric Governance solution for Impact Analysis.
In this solution, all of your metadata is outputted to a Fabric Lakehouse and can be scheduled via a Fabric Pipeline. The final output also includes a Power BI Model / Report template to easily view exactly where you visualize everything in your model.
Use case:
I need to change the column name 'Amount' to 'Revenue'....Revenue makes it more clear as to what it is
A quick check in this solution will show me that making that change affects 2 workspaces, 2 reports, 6 pages, 11 visuals, etc.
You can even hover over each line to see exactly where the visual sits on the page -> and the included link will take you directly there.
The solution only requires 1 notebook that leverages the power of Semantic Link Labs and a template model/report that will auto refresh upon opening once it has the Lakehouse connection string.
Three steps for an easy run:
- Download and Import Notebook
- Create a New Lakehouse (with schemas) and use it as the default lakehouse
- Run
Once complete, grab the Lakehouse's SQL endpoint connection string (steps shown in repo)....open up the Power BI Governance Model.pbit and after its refresh, get the full visual-level lineage you need to make smart changes. You can then publish the model/report to any workspace to schedule refreshes within the Pipeline set up for the notebook!