Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Can anyone please let me know how can I display dataset's last refresh date of my power bi report? I want to display below date. I want this option on report, not on dashboard.
I
Shikha
"Home" -> "Enter Data" -> Just create a blank one --> Create Column --> "
If you are using Analysis Services and you use Automation Accounts in Azure to refresh it you can add line to your code to put date of refresh to table in SQL Database. Then you connect to this table in AAS and use MAX([LastRefreshDate]) in your report.
It's not easy but it's exatly what you need.
Create a new Blank Query, and then add this into the Advanced Editor:
let
Source = DateTimeZone.FixedUtcNow()
in
Source
Then any time your report is refreshed, you'll be able to use this to show the date/time of the refresh.
We can use the following to Adjust the timezone:
let
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),-5)
in
Source
Thanks for you quick response. My report is based on direct query, so I won't be able to create Blank Query. What do you suggest for this?
If it's directquery, then you could just create a new DAX measure:
Last Refresh = UTCNOW()
UTCNOW() displays current UTC timing, whenever we open the report. But whenever a report is opened that does not mean dataset is refreshed. So I want to show last refresh time from dataset, which is shown below.
If you're in directquery mode, anytime you open the report in the Power BI service the query is refreshed
From: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
"When opening an existing report in the Power BI service, or authoring a new one, the underlying data source is again queried to retrieve the necessary data."
Hi @Anonymous
Below is the similar post for your reference.
Regards,
Cherie
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |