DirectQuery not updating on new day

[ukhc001]

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 sql database to return orders from that day, then groups by salesperson.

The dashboard has yesterday's total sales - when I open up the power bi designer file it refreshes to today's sales.

[ukhc001]

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]

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]

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]

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]

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

[WillT]

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

[ukhc001]

hi

i have the issue again. it is a direct query so no refresh settings available.