Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
How to show the latest dataset refresh details which is showed with green arrow in the power bi app Card visualization ?
Solved! Go to Solution.
Hi @suvechha ,
Within Power BI Desktop, you can add another Power Query dataset to display the current date each time we refresh the report. You may create a new Blank Query, and then add this into the Advanced Editor:
let
Source = DateTimeZone.FixedUtcNow()
in
Source
These examples use UTC. You can adjust the query code based on your specific timezone as described in DateTimeZone functions.
For example:
let
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),-3)
in
Source
For reference:
Display Last Refreshed Date in Power BI
Create a column in Power BI for last refresh date
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @suvechha ,
Within Power BI Desktop, you can add another Power Query dataset to display the current date each time we refresh the report. You may create a new Blank Query, and then add this into the Advanced Editor:
let
Source = DateTimeZone.FixedUtcNow()
in
Source
These examples use UTC. You can adjust the query code based on your specific timezone as described in DateTimeZone functions.
For example:
let
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),-3)
in
Source
For reference:
Display Last Refreshed Date in Power BI
Create a column in Power BI for last refresh date
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@suvechha , refer this link for detailed steps
https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/
HI @suvechha
We need to generate the Last Refresh date ourselves using Power Query. No big deal, it is as simple as this:
let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source
To finish it off, we need to create a simple measure and add it to our dashboard.
Last Refreshed (Local) = FORMAT(LASTDATE(LastRefresh_Local[LastRefresh]),"mmm dd, yyyy hh:mm:ss AM/PM")
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |