Forum Discussion
Direct query update stops
Any date range filters in the filter pane?
sounds like your data model also includes tables that are fed by import mode queries ?
No, I have the problem when I connect my model to only one table in direct query mode (this was also my first thought what could be causing this).
Any date range filters in the filter pane?
Yes I have (forgot about it) I will test without the filter.
The filter uses the function DateTime.LocalNow() to only get the records from the past 40 days untill now. Maybe there is somthing wrong with the 'untill now' part.
It will take a few days, before I know it keeps working, I will keep you posted. (Strange thing is somthimes it even stopped on the same day).
There may be some caching going on too. Usually with Direct Query you want to keep the transforms at a minimum, or at least guarantee that they fold completely.