Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have several reports which have separate dataset files on the workspace, but they essentially can work with any one of those datasets. Is there any way to have a single source of data for them, in order to save space on the server?
Solved! Go to Solution.
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-datasets
not sure about the merging, have a read here - it does describe how to edit existing datasets, but not sure about merging or changing
I'm not sure I get the question - do you want to merge the existing datasets? if so you can do that in the Query Editor by creating a new dataset that would have all the data required
if that's not what you intend to do, can you then elaborate on what you try to achieve?
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?
for sure you can do it with the new reports, as described here:
https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets
not sure about the merging, have a read here - it does describe how to edit existing datasets, but not sure about merging or changing
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |