Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We currently use the Enterprise Gateway to connect to our on premise SSAS tabular models and SQL Server databases on our Premium Capacity. We are in the process of replacing our servers with new servers on different internal domains.
We need to update the connections to all of our dashboards\reports to point to our new servers.
Is there a script that we can run that will allow us to change the connection on all of our datasets that have been published to our PowerBI Premium capacity?
Hi @Anonymous,
You could consider changing the connection string by Power BI Rest API, but it's complex and only supported in DirectQuery model. Please refer to below similar threads:
Power BI Rest API - Update All Connections?
Power BI API to change Database dynamically
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.