cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Change Datasource in the Service

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...

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Change Datasource in the Service

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Super User
Super User

Re: Change Datasource in the Service

You can't do anything with the data model in the Service, including changing data sources.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Change Datasource in the Service

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 269 members 2,695 guests
Please welcome our newest community members: