Forum Discussion
Helper IIncremental refresh seems not take effect
Hi JosieGuo ,
Thanks for Tutu_in_YYC and lbendlin reply, that's really helpful.
JosieGuo As a supplement, a refresh beyond 2 hours will cause a refresh failure in a non-premium capacity. I recommend you buy premium capacity to increase refresh time limit to 5 hours.
If your report is already in premium capacity, you might consider using XMLA endpoint to create more advanced partition and refresh scenarios to improve refresh performance. With Premium capacities, refresh operations performed through the XMLA endpoint have no time limit.
Please refer to the following documents:
Best regards,
Mengmeng Li
Super UserBuckle up, this will be a wild ride. First things first:
- what is your data source and does it support query folding?
- I assume that you are aware that each time you publish from the Desktop to the workspace the incremental refresh partitions are gone, and will only be recreated on the next refresh
- how many rows in each partition?
- have you used SSMS or DAX Studio to validate that the partitions have been created properly and filled properly?
JosieGuo1. the data source is azure synapse analytics SQL
2. I think it support query folding, and I check there is no warning message about non-foldling when I set the incremental refresh settings and it can show native sql query in transform page.
3. yes, When I publish the reports again, the historical data I already refreshed before will be cleared. Is there any way to don't clear the historical data?
4. I have about 10 tables in my reports, and the max one is 500,000 rows for one day.
5. Yes, I have checked in SSMS