Forum Discussion
Incremental refresh failure
Working with premium capacity and building dataflows. Having pretty much all tables on incremental refresh - 36 monthly chunks. doing it mostly to force partitions and thus avoid running out of memor...
pallavi_r
Super User
Super UserHi PlausibleDenial ,
1. Hope you have enabled large dataset storage format in Power BI dataset setting.
2. Another possible cause could be that query folding is not happening. You can easily check this issue by right clicking query setting. If view native query is enabled, then query folding is working fine.
Most probable reason for failure is data type mismatch between data type in the source and power query.
3.If 1 & 2 are successful then try configuring with Advanced XMLA endpoint.
What is your dataset size? Few microsoft links to help you out.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla
Thanks,
Pallavi