Forum Discussion

ZikoPowerBI's avatar
ZikoPowerBI
Icon for Helper II rankHelper 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
ZikoPowerBI's avatar
ZikoPowerBI
Icon for Helper II rankHelper II
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper 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
      Icon for Helper II rankHelper 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
        Icon for Super User rankSuper 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.