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

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

    The table is connected to 6 other child tables. After removing one of the child tables in Power Query, the data loaded into PBI Desktop quickly this time. I also checked the database for constraints and indexes, and everything seems to be in good order. Could an incorrect relationship in the PBI data model have caused the issue?

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

      If you refresh an incremental refresh partition all of its dependencies will be refreshed as well. That is especially devastating when you have Auto Date/Time enabled.

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

        Thank you. I don't know why, but I had to apply the RangeStart and RangeEnd on both the parent table and one of the other child tables. This way the tables are loaded into PBI desktop quickly.