Forum Discussion

ukhc001's avatar
ukhc001
Regular Visitor
10 years ago

DirectQuery not updating on new day

I have set up a directquery using the enterprise gateway.  It refreshed perfrectly on my dashboard during the first day, but then hasnt updated on the next day.   It uses a filter in the query to a...
Need Help
ukhc001's avatar
ukhc001
Regular Visitor
10 years ago

I checked my dashboards and it appears that it has refreshed to the correct day, but it did this at around 10am rather than 00:01?

 

Now, I also changed the power bi file held at onedrive - does the direct connect look at this file at all or has it imported the query into the power bi system?

  • Bjoern's avatar
    Bjoern
    Continued Contributor
    10 years ago

    As soon as you have published the pbix-file to the web-service, it should not care about the pbix stored locally in Onedrive. Nevertheless, of course, the reports in the PBIX-file should also get refreshed, as soon as the source data changes.

     

    For the WebService: Please test whether only the dashboard does not refresh properly, or this also applies for the reports?

     

    Data flow:

    Source -> Report -> Dashboard

     

    Is the issue between source and report or between report and dashboard? Dashboard refresh seems to have some trobules sometimes.

    • ukhc001's avatar
      ukhc001
      Regular Visitor
      10 years ago

      It was both the dashboard and the report.  Does it matter when I created the filter 'today' in the pbix or should that always look to the dd of ddmmyy?

      • Bjoern's avatar
        Bjoern
        Continued Contributor
        10 years ago

        Which filter? Did you use it in DAX or a report-selection? Or in a slicer?

         

        In order to eradicat a timestamp-error, I would have tried it without a selection. Always start bottom-up with cool stuff. Not going "full fledge mode" and then being surprised, why it does not work at all. ;-)