Forum Discussion
Power query refresh
Hello, is it possible to make power query refresh the data and change the date to local? Because every day comes a new date and needs to pull out the current one
3 Replies
hi Dominikx1 ,
using the below statement provides the date from your locale :
Date.From(DateTime.LocalNow())
You could use this in a filter step, where the filter is equal to the above to filter today's data.
Alternatively, you could create a query with this value and reference the filter to the query's name if you want.
When you hit refresh now it should bring in only from that date.
Appreciate a thumbs up if this is helpful.
DateTime.LocalNow - PowerQuery M | Microsoft Learn
Let me know if this resovles your question.
