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