Forum Discussion
Combining Datasets Hosted in Multiple Premium Workspaces
I am currently working with a composite model with a couple of hundred MBs but have never had anything above 1GB. Cant you just test it out and see how slow it will be?
Alternatively, I am thinking maybe you can use some tools to combine your datasets.
Do you have reports connected to the datasets currently or do you just want to load everything? I would recommend only keeping things in the dataset that you are actually using somewhere in a report which will also cut down the size.
Hi Brunner_BI ! Thanks for your reply and suggestions. During my previous tests, I noticed it takes longer to render some visuals where data come from another dataset (with a direct query mode).
I learned I could copy reports from other workspaces (need to have build permission) to my project workspace (without duplicating datasets) and include them in my app. There are multiple limitations to this approach. For example, I can only edit visuals of the copied report in the service, and there is no way to edit a copied report on the PBI desktop. However, this approach will save me a lot of time, and it is sufficient, at least for the first iteration of my project.