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 -...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Any date range filters in the filter pane?

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

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