cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Switching data sources

Hi guys,

 

I'm sure there are different ways of doing this - I wanted to ask you guys what would be the most efficient/correct way in order to minimize rework.

 

I have a dataset which comes from an Azure db. I do some shaping and filtering with that data, creating different queries and intermediate tables. After that, I've built a few reports using those tables.

 

Now, I've recently had to change my data source to a different Azure db (all the structure remains the same). How can I do this in PowerBI without having to make the dashboards and shaping again?

 

Thanks!

1 ACCEPTED SOLUTION
Super User IV
Super User IV

Easiest way is to use the Advanced Editor in the Query Editor and just edit the Source line to point to the new DB. Would have to see your source line to tell you specifically.

 

In the future, consider using parameters to parameterize the server name/db name.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Easiest way is to use the Advanced Editor in the Query Editor and just edit the Source line to point to the new DB. Would have to see your source line to tell you specifically.

 

In the future, consider using parameters to parameterize the server name/db name.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Seems straighforward enough. My source line looks pretty simple Source = Sql.Database("MyAddress"). It seems that all I have to do is replace the Source line with the new DB for all queries.

 

I will look into the usage of parameters. Thanks for the help!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors