Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ZikoPowerBI
Helper II
Helper II

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 7
lbendlin
Super User
Super User

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!

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.

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".

 

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

 

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!