Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gdssiqueira
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
Greg_Deckler
Super User
Super User

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors