Forum Discussion
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 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.
7 Replies
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?
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.
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?
