Direct query update stops

[Elbartje1]

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 - 6 days) no fixed time or I don't know what is triggering this, the query does not add new records to the data. If I change excisting records in the database I can still see the changes in the report but newly added records are not showing. I get no error messages.

If I republish the report all works well again, for a while...

I did multiple tests, different reports, combine import data + direct query data, only direct query data, very simple query, nothing seems to work.

I hope someone can point me in the right direction!

Bart

[Elbartje1]

Problem is solved, the localtime function was causing a strange behaviour.

[lbendlin]

sounds like your data model also includes tables that are fed by import mode queries ?

[Elbartje1]

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

[lbendlin · Accepted solution]

Any date range filters in the filter pane?

[Elbartje1]

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

[lbendlin]

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.