From the course: Learning Power BI Desktop

Unlock the full course today

Join today to access over 23,400 courses taught by industry experts.

Change the data source for a PBIX file

Change the data source for a PBIX file - Power BI Tutorial

From the course: Learning Power BI Desktop

Change the data source for a PBIX file

- [Instructor] When we create a data model and save it as a PBIX file, we begin by getting data from a source. And when we saved this PBIX file, that data source connection was saved as part of the file. And I can see that if I go to Transform data, Data source settings. This is the location for the original Excel spreadsheet that was used as the basis of the medianage.pbix Power BI data model. Now your PBIX file will have a different path, a path that goes to wherever you stored that original Excel spreadsheet. So far so good. But if you send me your median age PBIX file, and I save it somewhere on my computer, even if I save it along with the Excel spreadsheet, the path won't be the same. I won't have the same set of folders that you have. And this is true in the opposite direction. The PBIX files that are included in the exercise files actually have passed the point all the way back here to my computer in Michigan.…

Contents