legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,214
- Office Version
- 365
- Platform
- Windows
I have multiple pages on my PBI file and on the first page I have refresh date/time stamp which shows the latest refresh if I click the Refresh button on the menu. The issue is this only works if the table in the first page is being refreshed. How can I display the refresh date/time stamp if any of the tables in the other tabs are being refreshed so I know my data has changed? I sometimes make changes to my queries and when I click Close & Apply it refreshes the tables but not the last refresh date/time stamp because the table in the first page was not changed. To put in another way, if any tables in the other pages is refreshed individually the last refresh date/time should show in the first page.
Here is my current code:
Here is my current code:
Power Query:
let
Source = DateTime.LocalNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type datetime}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Last Refresh"}})
in
#"Renamed Columns"