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

    • ukhc001's avatar
      ukhc001
      Regular Visitor
      10 years ago

      Not that complicated :) I just used the drop down filter within the power bi desktop to set as day = today.

      • WillT's avatar
        WillT
        Community Admin
        10 years ago
        Hi - when you configure the data refresh there is an option to say what schedule you want it refreshed on. It's including the timezone - so worth checking that's your local area! This is when we start to kick off the refresh. There are a number of factors that'll affect how long it takes (network to your data source, resources in our service, query time on your database etc.) so we can't guarantee that it'll be complete by a certain time.

        Hope that clarifies
        Will