Forum Discussion
DirectQuery "[Posting Date] = latest" issue
Here is the answer:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Do not use the relative data filtering in Query Editor. It's possible to define relative date filtering in Query Editor. For example, to filter to the rows where the date is in the last 14 days.
However, this will be translated into a filter based on the fixed date, as at the time the query was authored. This can be seen from viewing the native query.
Community SupportHi MCKERY,
You said that the filter didn't work in the following day, I want to know whether the Posting Date will update each day? If it will update each day, this might be related to refresh, so if you refresh the dataset, then you view this report in service , will it work well?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dax ,
Thank you for the response. I thought I had fixed the issue but then it recurred.
The table in question is transactional date, so a new posting date will appear with a new day.
As a work around, I am able to refresh the dataset in PBI Desktop and then re publish the report to the Service. The service will now pull the correct data.
Something is happening where the "latest" pulls a date that then becomes static with future queries on future days instead of pulling an authentic "localnow" date on each query. Being DirectQuery it should send the whole query to the source, no?
Michael