Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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? 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |