Forum Discussion

PBIMike's avatar
PBIMike
Helper III
6 years ago
Solved

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

 

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

 

 

Need Help
  • Icey's avatar
    Icey
    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.

2 Replies

  • Icey's avatar
    Icey
    Community Support
    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's avatar
    PBIMike
    Helper III
    6 years ago

    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? πŸ™‚