Forum Discussion
Bulk Update of Semantic Model Data Source for Multiple Reports
There is no native UI-based "bulk rebind" in Power BI, but there are two primary methods to achieve this but one involves the API and is not that straight forward. The easiest approach is tedious but bullet proof
- Open the .pbix file in Power BI Desktop (assuming you have a local copy or download from the Service).
- Go to:
- Model View > Transform data > Data source settings
- Click Change source > Select the new semantic model.
- Ensure compatibility with fields, measures, tables.
- Save and re-publish the report to the Service.
Watch out for broken visuals if there are schema compatibility issues between your two models.
Particularly if you
- Renamed or removed tables/fields/measures
- Changed relationships or calculated columns
Please mark this post as solution if it helps you. Appreciate Kudos.
Hi VanThuan ,
Currently Power BI does not provide a built-in feature for bulk updating or rebinding multiple reports to a new semantic model via the UI. As you noted, replacing the original model would erase historical data, so that's not an option. The most reliable method, although manual, is to open each report (.pbix) in Power BI Desktop, go toModel View > Transform Data > Data source settings, and update the data source to point to your new semantic model.
After ensuring schema compatibility (i.e., no renamed or missing tables, fields, or measures), save and republish each report. Alternatively, for a more scalable solution, you can consider using the Power BI REST API to programmatically rebind reports to a new dataset, but that approach requires scripting and administrative access. Always double-check for schema differences between the old and new models to avoid broken visuals. Hopefully, future updates to Power BI will include a more streamlined bulk rebinding option.
I created a new application for migrations which would download, upload and re direct the data sources for all the Power BI Reports from Fabric Workspace. Here is the link to the tutorial and the App is in the comment section. Let me know your feedback