Forum Discussion
Power BI incremental refresh problem
Question on power bi incremental refresh. Have this setup and having an issue when running incremental refresh from the service: non folded TOP 1000 queries equal to the number of partitions chosen f...
From what I can tell, it's running a data preview query for every step in the power query script * the number of partitions. So if # of partitions is large, an insane number of these queries are run - and the source is big data/ADLS Gen 2 with spark on top
jtclabaugh Did you find a solution for this. We are running PBI over big data much like yourself. We have large PBI models in premium capacity with incremental refresh configured. We are also using the "Detect Data Changes" feature in hope of speeding up the daily refresh. The top 1000 queries are really affecting our refresh tuning. Did you find anyway around this issue?