Forum Discussion
Solved
Direct query update stops
Hello all, I have a direct query connected to an oracle database. When I publish my report to PowerBi online (gateway is setup correctly) all works perfect. But after x amount of time (1 hour -...
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.