Forum Discussion

bdpr_95's avatar
bdpr_95
Helper IV
10 months ago
Solved

Best Approach for User Access Table with Different Refresh Frequencies

Hi everyone, I'm working on a use case involving 20 Power BI reports. For 10 of these reports, the fact tables are updated daily, while for the other 10, the fact tables are only updated monthly. M...
Need Help
  • bdpr_95's avatar
    bdpr_95
    10 months ago

    v-echaithra, I plan to use import mode for all tables and configure pipelines to refresh the monthly reports and update the daily user access table.

pallavi_r's avatar
pallavi_r
Super User
10 months ago

Hi bdpr_95 

 

I would go ahead with direct lake for both approach keeping daily detailed table separate and monthly aggregated detail in a materialized view and both are to be accessible in direct lake mode.

 

Direct lake does not need refresh.

 

Regading your 2nd question on monthly refresh of Power BI report, please check this link and below snapshot.

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

In your pipeline also, you can refresh the dataset in notebook or leverage semantic model refresh activity

https://learn.microsoft.com/en-us/fabric/data-factory/semantic-model-refresh-activity?utm_source=chatgpt.com

 

If this post helps, appreciate your kudos.

 

Thanks,

Pallavi