Forum Discussion
One giant data model?
This is a perfect ground for an excellent Power BI dataset organization! I recommend you go ahead with this . The approach generally taken is that the power BI datasets are built and deployed to service without any visual in them. So these serve as dataset only reports. These datasets can be then used to build multiple reports by connecting live to them by multiple developers at the same time. This has several benefits :
The updates to datasets done would reflect on all live connected reports automatically.
The visual reports are lightweight and easy to maintain and work with in respective Desktops.
The deployments to environments simply needs Datasource updates in pbix
The self-service goal is better realized where business can even build their own reports connecting to these well defined datasets.
You would be able to use Tabular editor and also manage RLS centrally in the datasets
Please let me know if you need further information in this set-up
AbhiSSRS Great feedback. Just to confirm, you are advocating that I proceed with the subject matter dataset architecture?
And one related question. When we reports in the service, is there a trick to being able to start with a blank page that already has a custom color theme applied? We publish most of our reports from desktop today so we can easily apply a theme.