Forum Discussion

Elbartje1's avatar
Elbartje1
Frequent Visitor
3 years ago
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 - 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

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

    • Elbartje1's avatar
      Elbartje1
      Frequent Visitor
      3 years ago

      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's avatar
        lbendlin
        Super User
        3 years ago

        Any date range filters in the filter pane?

  • Elbartje1's avatar
    Elbartje1
    Frequent Visitor
    3 years ago

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