Forum Discussion

amir_mm's avatar
amir_mm
Icon for Helper III rankHelper III
2 years ago

Incremental refresh - Table keeps loading in PBI desktop

Hello,   I defined new parameters on a date/time column in one of the tables (RangeStart and RangeEnd), and filtered the column to a custom date range, but when loading into PBI desktop the table k...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Every time you make structural changes Power BI Desktop throws away all meta data and recollects it. Set your RangeStart and RangeEnd to two adjacent dates,  then let Power Query do its thing and do not interfere. Messing with it will make it worse.

 

Do not attempt anything fancy in the Power Query code - no merges or sorting!

  • amir_mm's avatar
    amir_mm
    Icon for Helper III rankHelper III
    2 years ago

    I did the same. There is no merging, sorting or anything. Set RangeStart and RangeEnd to one day only, and again when loading into desktop it just keep loading and spinning. 
    other tables work just fine. 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      can you show a sanitized version of that Power Query code?

      • amir_mm's avatar
        amir_mm
        Icon for Helper III rankHelper III
        2 years ago

        This is the query after defining the parameters. It just keep spinning ...