Purpose & scenario
This notebook demonstrates how to make a Power BI dashboard portable by parameterizing and programmatically re-binding field references in a report definition. The result: a reusable template you can deploy to a different semantic model with minimal manual effort—useful for multi-workspace/customer scenarios and catalog/factory patterns.
How it works
-
Loads a reference template report
-
Maps template placeholders → fields in the target semantic model
-
Uses semPy to update bindings in the report definition
-
Encourages Visual Calculations and report-specific measures (with a dedicated home table) to reduce tight coupling
Quick start
-
Add the notebook to a Fabric workspace (capacity-backed).
-
In the configuration section, set: workspace_id, dataset_id, act_measure, bud_measure, dimension, report_name_override.
-
Run the notebook cells in order.
-
Open the generated report and verify the Monitoring Dashboard.
Requirements
-
Fabric capacity + Contributor (or higher)
-
Build permission on the target semantic model
-
Python in notebooks (Preview); semPy enabled
-
Semantic model name must not end with a trailing space
-
No sensitive data is required (uses a public reference model)
Reusability & clarity
-
Clean, commented steps (load → map → apply → validate)
-
Externalize mappings (CSV/JSON) for repeatable deployments
Credits
Publication & acknowledgments
This Proof of Concept was developed with the assistance of ChatGPT and published for the Fabric Notebooks for Power BI – August Contest.
Disclaimer
Provided as-is for demonstration purposes. Use at your own risk; no liability for any damages.
Github-Repository
https%3A%2F%2Fgithub.com%2FMarcusWegener%2Fpbi-dashboard-template-notebook%2Fblob%2Fmain%2FDeploy_Monitoring_Dashboard.ipynb
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
