Forum Discussion
Best Power BI Architecture for Multiple Reports with Dynamic RLS and Different Refresh Frequencies
- 6 months ago
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
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 model
https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#refresh-a-semantic-model