So I havea dashboard with 3 tabs.
Onboarding
Active Employees
Background checks

The onboarding is updated constantly throuought the day and I used a dax formula to basically show the exact date and time the refresh button was "hit"(it is set to automatic refresh.

The background check and Active employees however are sort of manually updated. They are still sharepoint list so they update automatically with everything else but the BGC report is updated in sharepoint once a day at 6am.

The active employees sharepoint list is updated once a week on wednesday, when I get to it, basically downloading an excel from our client and uploading it to sharepoint.

What would be the best way to show the accurate refresh date and time for these two other reports because they technically refresh right along with the onboarding but nothing changes throughout the day because the sharepoint lists dont change.

I thought about maybe just adding a column to each that shows the update date and time and just using that as a card or something but wasnt sure if there was a better way.

  • After your question has been solved /u/trollsong, please reply to the helpful user's comment with the phrase "Solution verified".

    This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

    I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

    parent

  • That's pretty much it I reckon. Just refer to the modified date in the SharePoint data

    parent

    This is what I do. Max of last modified date as a “source system data as of”

    parent root

  • for when i need to show when a dashboard last updated itself
    i make a blank query
    put in it =DateTime.LocalNow()
    convert to a table

    change type to date
     

    then you can use that in your report in a visual or in a measure as needed

    parent

  • DateTime.LocalNow() can have some problems when using gateways and things like that. If you know what timezone you want to report in, a nice trick can be calling out to a website like timeanddate.com and using their data to ensure that whatever timezone you want to show is always accurate.

    Works nice if you want to show multiple timezones and not worry about conversions yourself or DST and all.

    Here's an example for showing the refresh date based on central (Chicago) time.

    let
// get the data from a stable source in table format from the web

    Source = Web.Page(Web.Contents("http://www.timeanddate.com/worldclock/")),

//PowerBI does automatic detection
    Data0 = Source{0}[Data],
    #"Removed Other Columns" = Table.SelectColumns(Data0,{"Column4", "Column5"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each Text.Contains([Column4], "Chicago")),
    #"Removed Other Columns1" = Table.SelectColumns(#"Filtered Rows",{"Column5"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns1",{{"Column5", type datetime}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column5", "Latest Refresh"}})
in
    #"Renamed Columns"
    parent