It may be a combination. You could have one big dataset with most or perhaps all of the data, and then share that dataset to the otehr departments. You can then restrict what they can and cannot do/see. So your primary data set can have Sales, but you don't expose Sales to the Engineering team for example. You need to have the new Gen2 workspaces to do this, so if you have Gen1, click the little upgrade button in the workspace settings.
There is no perfect solution to your issue - it is all about optimization, not perfection. Share Datasets has been a HUGE boon for me in this processes, but there are still times I completely segregate data and datasets. That, and I've not pulled the trigger on upgrading all of our workspaces to the new Gen2 type yet.
Yes, several departments uses the same kind of data.
However, RLS feels a little bit weird. When people open up the reports and just see blanks on one page?
But I think I will go back from multiple datasets to two datasets. Just a mess to keep track on measures and changes in measures between datasets.
Thank you so much to both of you!
One thing you could do to customize reports for different departments but still use a common data model is to publish the report + model to the Power BI Service. Then you create a new report and connect it to the dataset in the service:
Yes, but that still requires one BIG dataset, which means the reports will still be a bit slow compared to smaller ones.
But I guess it's all a matter of a balance. Can't have both.
Yes, it's a matter of balance.
How complicated calculations you have and the structure of the model is in many cases more important than the number of records. I have made dimensional models (with facts separated from dimension attributes) with up to a 100 million rows and the performance is still very good... And with partitioning (incremental refresh) avaiable in Power BI Pro updating of the data is no longer an issue for large models.
Seriously, did they remove that limitation like this week or something?
Seems to be open for Pro users now? 😍
Different subject areas and data that is not related should go into different data models. But if several departments uses the same kind of data, let them share a large model with data from all departments. Then add roles to the model and use row level security to let the users see only the parts od the data they are allowed to see. You will then only need to deploy the report to one workspace/app and users from different departments can use it and see different numbers.
To avoid problems with relationships, use some structured design strategies when creating the data model. Dimensional Modeling is a VERY good modeling teqnique for Power BI.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.