Forum Discussion
PBIMike
6 years agoHelper III
Date Last Published
Hello, I found some helpful guidance on these forums to be able to produce a "Date last refreshed" measure by using: = Table.TransformColumnTypes(#"Renamed Columns",{{"DateTime", type datetime}}...
- 6 years ago
Hi PBIMike ,
Maybe you can try this:
1. Create a blank query in Power Query Editor like so:
let Source = DateTime.LocalNow(), #"Converted to Table" = #table(1, {{Source}}), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "LastPublishedDate"}}) in #"Renamed Columns"2. Keep "Include in report refresh" unselected.
3. Create a Card visual to show "LastPublishedDate".
4. Before publishing the report, you need to refresh the data of the "LastPublishedDate" table, not refresh the report.
In this way, every time you refresh the report and dataset will not affect the last publishing time.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PBIMike
6 years agoHelper III
Of course there may just be a default setting in the browser version of Power BI that lets users see this as standard, that I just haven't found yet? 🙂