cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Change data source for the whole pbix file

Assume I already have pbix file using "Import Data" approach which is imported around 50 tables from Database 1. Now I want to change Data source of this pbix file to Database 2 which is exactly the same database schema.

 

I see one way to open Adance Editor each table to change the Source, this way works but I have to manually change Source 50 times for 50 tables. Is there any other approaches that I am able to change Source in one time for every tables.

 

 

Capture.PNG

 

1 ACCEPTED SOLUTION
Skilled Sharer
Skilled Sharer

The technique I know only works prospectively.  It is explained by Chris Webb here, and involves declaring the elements of the data source as a separate M query: http://blog.crossjoin.co.uk/2015/11/09/avoiding-duplication-of-database-connection-information-in-po...

 

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

View solution in original post

5 REPLIES 5
Advocate I
Advocate I
Skilled Sharer
Skilled Sharer

The technique I know only works prospectively.  It is explained by Chris Webb here, and involves declaring the elements of the data source as a separate M query: http://blog.crossjoin.co.uk/2015/11/09/avoiding-duplication-of-database-connection-information-in-po...

 

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

View solution in original post

@asocorro This way does not work when we publish to PowerBI service and do data refreash over enterprise gateway.

What kind of error are you getting?

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

Awesome! Thanks a lot

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors