Filtering "in the previous" days in directquery does not update

[grijs]

In one of my live directquery dashboards I want to show results of the previous 30 days. When editing the query, I can filter the date column on "In the previous..." and then select 30 days. This works well, until.... I publish the report to Power BI service. From this point no new data appears in the dashboard. Is there anything I can do to solve this?

[v-caliao-msft]

Hi @grijs,

To update your data, Enterprise Gateway must be installed and the data source must be registered to establish a data connection. 

Using Direct Query with On-premises data sources, there is no need to configure Schedule refresh.

Read more about this under the Live connections and DirectQuery to on-premises data sources part in the article below:

Data refresh in Power BI

I have tested it on my local environment, everything works fine.

Regards,

Charlie Liao

[grijs]

This is not the problem. I checked this and indeed it says that the gateway and data sources are online. I can also see that the live connections are working, that is fine. But only when I filter the data on a date field with the 'In the previous' option, it seems that the current date is not updated. When configuring the dashboard and filtering on the previous 30 days everything works fine, but when I come back the next day, still the same data is shown, that is the data from the day before yesterday until 30 days back from the day before yesterday. I would expect that the date window is shifted one day forward, because only then this is a useful live dashboard.