Hi I have a Latest refresh Date table (M code below)
This updates fine in Power BI Desktop, but when it is published it does not update when a scheduled refresh runs from the Workspace, despite all other data updating.
At first I thought it was because I used it in the Text field as a value, but even if I replace it with a Table field, it does not work. Has anyone else encountered this and do you have a solution?
Power Query also has Refresh Enabled on the table just as an update.
@ Keith from Finance - I didn’t find anything on the forum about this specific issue other than adding the latest refresh date and I checked more than one place before I came here for a solution, but thanks for your feedback.
I have attached a text file containing the various bits of M code and DAX to create a Last Updated value for Power BI service reports, including handling DST for many time zones. The value will be updated each time the dataset is refreshed.
Once the pieces are set up, you just add a text box visual to display the DAX “LastUpdated” value. Note that the time value is when the refresh completed.
The text box value displaying the DAX function result appears like this in my report (I’m in the US, EST):