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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cuongle
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
asocorro
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

8 REPLIES 8
odegarun
Advocate I
Advocate I
asocorro
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

@asocorro Hello, 

 

I have pbix file sent by a colleague and I want to use the same pbix file including my colleagues template for my own data.How do I do this?

Kind regards

M

Hi, you would have to do a query-by-query analysis to see where the data for each table in the report is coming from and then replace those sources with yours.  In Power BI, a report can get data from many sources at once (e.g., databases, Excel files, etc.).

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

Thank you. I guess its how to change the data source so it reads my own data

@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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors