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