The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
How can I display the last refresh data when there is new data? I found this formula but it gives me the date everytime the dashboard refreshes, I have it automatically refreshing a couple times a week. It refreshes using a file that is automatically generated which my dashboard pulls from. We want to know if that file for some reason fails to be generated, that we are still running on old data.
"let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source"
Example, on 1/1/22 my file is automatically generated and my dashboard refreshes, it will show last updated: 1/1/22.
On 1/2/22 there is an error and my file does not automatically generate or rewrite over the old file, my dashboard still refreshes using the old data and shows that the data was refreshed on 1/2/22, when actually it's just old data. So because it's old data I want the card to show 1/1/22 even though it technically refreshed, it has old data. This would help be an indicator of when my file is not automatically generated.
Is there any way for me to have a card that shows the last time there was new data uploaded and refreshed?
I'm sorry if this is confusing!
Thank you,
Ally
Solved! Go to Solution.
No. You have two options:
But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@a_yang - The first thing that occurs to me is that when Power BI Dataset refreshes, if there is an error loading data today, the previous Dataset is not replaced. Effective, when you view the Report/Dashboards you will see the old data, but also the Last Refreshed datetime would not have been replaced. The Power BI dataset refresh needs to replace all objects. It won't replace the Last Refresh date if it can't load another object.
The second thing that occurs to me is that it might be possible to using an API to refresh individual objects in Power BI. This could refresh the Data table, check for successful change and then refresh the Last Refreshed object. This is an advanced refresh option that requires Premium Capacity.
No. You have two options:
But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you!