Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Currently I have about 10 data sets. All of them are used to create their own PBI reports. A few I'm also using to combine into a separate PBI report. So, for these combined reports, when I update the dataset, I have to update it twice as I'm currently not using shared datasets.
What's the best way to manage this?
Should I create one big shared dataset and just turn off refresh on the individual datasets that I'm not using for that report?
Should I create 10 separate shared datasets? If so, can I combine multiple shared datasets into one report?
Any good tutorials out there on shared datasets?
Solved! Go to Solution.
Hi @bryanc78 ,
Do you mean data source rather than dataset which in the Service? You want to update once the data source. And then the separate PBI report and the report which is combined many data source both refresh. Right? If so, I think you could create a big shared dataset to create report separately. Then set schedule refresh in the Service. All the report using that dataset will up to date. However, if the 10 data source is too big, the report may not run smoothly. It needs lots of time to load data.
For combining multiple shared datasets into one report, we only can get one dataset into Desktop to create reports for now. So the way is not available.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bryanc78 ,
Do you mean data source rather than dataset which in the Service? You want to update once the data source. And then the separate PBI report and the report which is combined many data source both refresh. Right? If so, I think you could create a big shared dataset to create report separately. Then set schedule refresh in the Service. All the report using that dataset will up to date. However, if the 10 data source is too big, the report may not run smoothly. It needs lots of time to load data.
For combining multiple shared datasets into one report, we only can get one dataset into Desktop to create reports for now. So the way is not available.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.