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.

Msingh16's avatar
Msingh16
Regular Visitor
10 months ago

For the monthly reports:

 

  • Keep the fact table in Import mode (since it only updates monthly).
  • Keep the user access table in Direct Query/Direct Lake mode (so permissions are always up-to-date).
  • This composite model approach works well, and report interactions will work smoothly if relationships are set correctly.

For Monthly refresh: Use the monthly refresh feature in Data Pipelines (preview) or automate the refresh via a notebook/Power Automate.