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...
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. ;-)
Not that complicated :) I just used the drop down filter within the power bi desktop to set as day = today.
- 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
Willhi
i have the issue again. it is a direct query so no refresh settings available.
