Forum Discussion
Change all excel file connection strings from one semantic model workspace to a new owner/workspace
Hi bobsaved ,
If you want to modify the connection to the semantic model in Excel:Sorry, you can't modify all the connections in bulk, you can only change them manually one by one.
If you want to modify the data source connection in pbix:Then you can try to publish to Power BI Service first, and then use the Rebind Report in the REST API to rebind the report dataset.
Reports - Rebind Report - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My bad. The pbix file is the 730 meg, excel file 77 meg. Any ideas how to change connection strings as noted?
Hi bobsaved ,
If you want to modify the connection to the semantic model in Excel:Sorry, you can't modify all the connections in bulk, you can only change them manually one by one.
If you want to modify the data source connection in pbix:Then you can try to publish to Power BI Service first, and then use the Rebind Report in the REST API to rebind the report dataset.
Reports - Rebind Report - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.