Forum Discussion
Solved
Best Power BI Architecture for Multiple Reports with Dynamic RLS and Different Refresh Frequencies
Scenario: Need to build 3 Power BI reports that share common dimensions (Geo, User mapping) but have different fact tables. One report has a very large dataset and requires bi-monthly refresh. ...
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
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you