Forum Discussion
Best Power BI Architecture for Multiple Reports with Dynamic RLS and Different Refresh Frequencies
For single semantic approach, you can run notebook that triggers targeted-table refresh. This way, only tables that need daily refresh, will be refreshed daily. And tables that need bimonthly refresh will only be refreshed bimonthly.
Here is a snippet of my code that targets just a table in the semantic modelhttps://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#refresh-a-semantic-model
Hi PK950309
The way I would approach it is if you can do incremental refresh on your large data set, then you can everything in one single semantic model. Meaning you have only one semantic model to manage which you can then apply your valuable security across and not having to maintain multiple models.
Just also remember that the size of the model might impact your capacity or your licensing requirements, so have a look at Power BI Pro or Power BI Premium per user as a potential option as quite often Power BI Premium per user gives you up to 100 gigabytes of in memory model capacity versus going with a fabric capacity which costs significantly more per month.
Thanks for the response.
We are using a Premium capacity workspace with an F64 SKU. Regarding the suggested approach, the PBIX contains 3 pages/reports. Two of these reports require daily refreshes with the full dataset, while the third report is refreshed twice a month, also with the full dataset.
The challenge with refreshing the tables for the third report on a daily basis is the large data volume involved. Additionally, we have SLA commitments for data refresh that must be maintained while considering the refresh requirements of the other reports in the same workspace.