Forum Discussion
single dataset refresh, we observe multiple SQL statements
Hi manoj_0911 -Yes, this is expected behavior. To add to oussamahaimoud's explanation, Power BI can generate multiple SQL statements during a single refresh cycle because it performs several operations behind the scenes, including schema validation, partition evaluation, change detection, and data retrieval. The exact number of queries may vary depending on the incremental refresh policy, number of partitions, and whether query folding is occurring correctly.
If you're investigating performance, I'd recommend reviewing the actual partition refresh queries and confirming that the RangeStart/RangeEnd filters are being folded to the source. This will help ensure the incremental refresh is operating as efficiently as intended.
Hope this helps.
Hi manoj_0911 -Yes, this is expected behavior. To add to oussamahaimoud's explanation, Power BI can generate multiple SQL statements during a single refresh cycle because it performs several operations behind the scenes, including schema validation, partition evaluation, change detection, and data retrieval. The exact number of queries may vary depending on the incremental refresh policy, number of partitions, and whether query folding is occurring correctly.
If you're investigating performance, I'd recommend reviewing the actual partition refresh queries and confirming that the RangeStart/RangeEnd filters are being folded to the source. This will help ensure the incremental refresh is operating as efficiently as intended.
Hope this helps.