Forum Discussion
Query Folding issue with Incremental Load on Service
Hi ,
Iam facing an issue in query folding with Incremental load parameters RangeStart and RangeEnd .
Whenever , I refresh the data in Power BI desktop the query folding shows appropriate values in where clause of the query that is set in parameters default value. However , when I deploy the same report to PBI service the query folding takes random values in parameters and this caluses the issue. Any help will be highly appreciated.
Thanks!
7 Replies
It's not random values - the Power BI service is managing the partitions according to your guidelines. The values you had specified for RangeStart and RangeEnd in Power Query have nothing much to do with the actual process - you can use them to limit your developer working data set, but the values will be ignored by the service.
Hi lbendlin Thanks for the prompt response!
Can you please help to put some light on how Power BI service is managing the partitions according to the incremental refresh guidelines?
any document / blog for reference can also be helpful.
Thanks!
