Forum Discussion
Solved
Last Refresh Date change Timezone
Hey, I added a new Table with one column to my report which should show the Last Refresh Date. I've created it with the following query: let
Source = #table(type table[Date Last Refreshed=datetime...
lkshck , I think you should use
Date.From(DateTime.FixedLocalNow())
for timezone refer if this can help
Found the esiest solution create a column in date table or any table Updated_at=Now() and add this as the value in text box
last updated at +value=max(Updated_at)
Works like a charm 🙂
Above didn't work:
I am seeing too much effort to get the last refresh date in the report. I have created a view with just one column updated timestamp and it is no working fine. Power BI is failing to calcualte Now() but I am sure it will not alter the value coming from the datasource.
That didn't work either for all reports. Seriously its working some places not the other, Finding new solutions. I don't want to try that api