Looking for a bit of guidance on best practices regarding how to structure queries, models and reports etc.
We have been developing Power BI reports at our company for a couple of years now and have defaulted to importing tables/views from the database into each Report and building the report as required. This has resulted in the same table/view being imported into several different reports, which is creating a lot of server activity as refreshes are performed (we try to stagger them and only update once overnight where possible).
Recently we have been shifting to creating power bi datasets to reduce server load, but we are now runing into the limitation that a report can only use one dataset (which means many many datasets are requried, some with only subtle differences).
Can you suggest are there any best practices for setting up datasets/data sources?
Or is there a way to build reports that use several datasets?
Thanks in advance!