Date Last Published

[PBIMike]

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}})

What I'd like to be able to do is show my online users the date/time data was last published. Is it possible to either:

1) Have a specific measure that would update to show the date/time last published, or

2) Make it so that clicking 'Publish' would automatically refresh the data before uploading?

Many thanks,

Mike

[Icey · Accepted solution]

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]

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? 🙂