Forum Discussion

Alaahady's avatar
Alaahady
Helper II
8 months ago
Solved

incremental refresh from an on-premises SQL Server into Power BI takes longer

I have a quick question. I’m pulling data from an on-premises SQL Server into Power BI and have created two semantic models: one with a full data copy and another using incremental refresh. I’ve bee...
data engineering
  • Anonymous's avatar
    Anonymous
    8 months ago

    Hi Alaahady ,

    Thank you for sharing the scheduled refresh details.

     

    This behavior looks expected. The initial longer refresh was due to incremental refresh creating and evaluating all partitions. The subsequent scheduled refreshes are completing consistently, which confirms that only the incremental partitions are now being processed.

    At this point, incremental refresh is working as designed. Please let us know if you notice any increase in refresh duration going forward.

     

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
8 months ago

Hi Alaahady ,

Thank you for sharing the scheduled refresh details.

 

This behavior looks expected. The initial longer refresh was due to incremental refresh creating and evaluating all partitions. The subsequent scheduled refreshes are completing consistently, which confirms that only the incremental partitions are now being processed.

At this point, incremental refresh is working as designed. Please let us know if you notice any increase in refresh duration going forward.

 

Thank you.

Alaahady's avatar
Alaahady
Helper II
8 months ago

Hi Anonymous 

Thank you for your kind support and explanation. 

Alaa