Forum Discussion

ZikoPowerBI's avatar
ZikoPowerBI
Helper II
2 years ago

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 val...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
2 years ago
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's avatar
ZikoPowerBI
Helper II
2 years ago

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's avatar
    lbendlin
    Super User
    2 years ago

    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.