Forum Discussion

Hendrik_LI's avatar
Hendrik_LI
Frequent Visitor
4 years ago
Solved

Avi Singh Power Query Calendar End Date not Automtically Updating in Direct Query

Hi All I am using this fantastic Calendar table that was developed by avisingh. I have used this extensively in Direct Query reports in the service. It dynamically populates the calendar table u...
Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Hendrik_LI ,

     

    You don't mention it, but I'm assuming you still schedule at least a daily refresh in the Service for your Direct Query reports?

    Even if all fact and dimension tables are running on Direct Query, queries like the one you've provided will require a traditional scheduled refresh in order to update.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Hendrik_LI ,

 

You don't mention it, but I'm assuming you still schedule at least a daily refresh in the Service for your Direct Query reports?

Even if all fact and dimension tables are running on Direct Query, queries like the one you've provided will require a traditional scheduled refresh in order to update.

 

Pete

Hendrik_LI's avatar
Hendrik_LI
Frequent Visitor
4 years ago

BA_Pete , thanks for that.

I haven't had the need to set a refresh schedule or manually refresh up until I started using this Power Query generated calendar in my Direct Query based reports.

Anonymous , it slipped my mind that the calendar is not a direct query. It's actually imported. Hence it not refreshing.

Thanks to you both!