Forum Discussion
Using Appended Query from Another File
Hi, newgirl
According to your description, do you mean that you want to change the data source of the main data table query of your Project 1?
To replace the original data source with a new one, there are two ways in the Power BI desktop:
- Go to Transform data-> data source setting, change the source of data:
- Go to the power query editor, advanced editor, replace the file path to change the data source manually:
What’s more, if you want to query all the tables in your Project 2, I think you can just use the “Connect to Power BI dataset” to connect to the underlined dataset of Project 2, you can follow this document:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The scenario you're describing is a typical use case for Power BI Dataflows (=Power Query in the web): Here you define, merge, clean-up your main data table and then reference this dataflow table in many different PBI models.
Introduction to dataflows and self-service data prep - Power BI | Microsoft Docs