Semantic Model incremental refresh for fact tables and regular refresh for dimension tables

Hi, JChohan , In Power BI, when applying incremental refresh to fact tables, dimension tables typically require a full refresh to ensure data consistency. To automate the refresh of dimension tables alongside the incremental refresh of fact tables, consider the following steps:

1. Configure Scheduled Refresh: In the Power BI service, set up a scheduled refresh for your dataset. This process will refresh all tables—performing an incremental refresh for fact tables and a full refresh for dimension tables.

2. Implement Incremental Refresh for Dimension Tables (if applicable): If your dimension tables are large and receive frequent updates, you can configure incremental refresh for them as well. This requires adding a DateTime column to track changes.

3. Ensure Query Folding: Verify that your queries support folding, allowing Power BI to generate efficient queries to the data source. This is crucial for the effectiveness of incremental refresh.

By configuring scheduled refreshes and ensuring your queries support folding, your dimension tables should refresh automatically along with your fact tables, eliminating the need for manual intervention.