Forum Discussion

Super User

2 years ago

Understand the incremental refresh partitions

I have a table where I configured fact_transactions (the source is a SQL Server table) the incremental refresh like below : The fact_transactions contains data of a monthly basis trasact...

Super User

2 years ago

I have data coming each 2nd business day for each month with the transaction date having the same value (as the 2nd business day) about 1000000 rows.

So what do you think ?

lbendlin

Super User

2 years ago

As long as the monthly partitions refresh in well under 5 hours that is ok.

AmiraBedh
Super User
2 years ago
Can you explain more how we can get 61 partitions? As I can't get anything to help me understand it in the documentation.
- lbendlin
  Super User
  2 years ago
  I think the documentation is pretty good.
  
  Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Forum Discussion

Understand the incremental refresh partitions

Related content

Create partitions along with the incremental partitions

Incremental Refresh – Archived Partition Overwritten After Refresh

Understanding Incremental Refresh

Understanding Lineage View

incremental refresh and partitionning