Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JChohan
Frequent Visitor

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

Hey guys, In my semantic model there are 5 fact tables and 10 dimension tables, incremental refresh is applied on all fact tables. The issue I'm facing is that fact tables are getting incremental refresh however dimension tables are not refreshing at all.

Everytime I need to manually refresh dimension tables and republish/redeploy the semantic model, whereas I am expecting all dimension tables to refresh automatically along with the incremental refresh on fact tables.

Please let me know where there is a change needed, thank you.

1 ACCEPTED SOLUTION
rohit1991
Super User
Super User

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.

View solution in original post

4 REPLIES 4
SaiTejaTalasila
Super User
Super User

Hi @JChohan ,

 

Based on the details provided you have created a composite model, and if you are doing any on-demand refresh or schedule refresh then only the tables in import mode will be refreshed. 

 

 

 

Thanks,

Sai Teja 

rohit1991
Super User
Super User

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.

JChohan
Frequent Visitor

Hi @collinq , it is the service where refresh for Dims doesn't happen, there is no error message. Incremental refresh on fact tables in service goes successfully everytime, with incremental refresh it takes 10 minutes to refresh on service, if refreshed on desktop with 'Refresh' button when all tables (dims and fact tables) it takes around 20 minutes to refresh.

collinq
Super User
Super User

Hi @JChohan ,

 

Are you in the Service or Desktop when you state that it is not refreshing?  Are you getting an error message?  How long do the fact tables actually take to refresh?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.