Query Folding issue with Incremental Load on Service

[ZikoPowerBI]

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!

[lbendlin]

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.

[ZikoPowerBI]

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!

[lbendlin]

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

[ZikoPowerBI]

Hi  ,

We observed that it is generating partitions with 0 rows in SSMS. I also tried a thread which says that we have to use Date >= RangeStart and Date < RangeEnd this also did not work.

[lbendlin]

We observed that it is generating partitions with 0 rows in SSMS. 

Good observation, but not an issue.  Just means you have no data for that range.

I also tried a thread which says that we have to use Date >= RangeStart and Date < RangeEnd this also did not work.

That thread is correct. Please qualify "did not work".

[ZikoPowerBI]

Hi - 

There is data in the database for those dates /range , but the partitions are blank which eventually shows no data for those dates in the report.

Please advice

[lbendlin]

Please show a sanitized version of your Power Query code.  If you can, show a picture of the partitions you observe in SSMS or DAX Studio.