Forum Discussion
Changing data source of multiple files to only one
Hi arghyam6,
you can create a shared dataset in your workspace which is connected to your data sources. This dataset is published to PBI service and is refreshed periodically (scheduled refresh).
Then you create another pbix file (just for visuals) which is connected to this shared dataset using a live connection. You can have as many pbix files with visuals as you want - let's say one pbix file for every report.More info: Connect to datasets in the Power BI service from Power BI Desktop
for sure you can do it with the new reports, as described here:
https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasetsnot sure about the merging, have a read here - it does describe how to edit existing datasets, but not sure about merging or changing
Hi Stachu
Not through query editor. I have several reports, and datasets published on the same workspace. Some of them essentially use the same queries from the same databases while refreshing. Can it be "merged" in such a way that only one dataset refresh will update all the reports that er using the same queries?
Hi arghyam6,
you can create a shared dataset in your workspace which is connected to your data sources. This dataset is published to PBI service and is refreshed periodically (scheduled refresh).
Then you create another pbix file (just for visuals) which is connected to this shared dataset using a live connection. You can have as many pbix files with visuals as you want - let's say one pbix file for every report.
More info: Connect to datasets in the Power BI service from Power BI Desktop
Thanks a lot.