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.
I'm working at a client site that doesn't have the fastest connection. I'm developing my report against a local database but once its deployed want to switch it to an Azure database. If I change the data source on the local file to Azure of course Power BI wants to do a full refresh which (even with the timeout pumped up) is hours and not effectively useful. Even saving it with the change and cancelling the refresh it still publishes with the local database as the source. Surely there must be a way to change the source on the published report. That seems like a gimmie!
I've seen the same question posted but time has passed and wondering if there have been changes - or additions in the API...
Solved! Go to Solution.
HI @Anonymous,
I think you can use query parameter to store connection string, then you can modify it on power bi service side.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,
BTW, current power bi service not support do data modeling.
Regards,
Xiaoxin Sheng
HI @Anonymous,
I think you can use query parameter to store connection string, then you can modify it on power bi service side.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,
BTW, current power bi service not support do data modeling.
Regards,
Xiaoxin Sheng
You can't do anything with the data model in the Service, including changing data sources.
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.