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 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!

  • 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