Forum Discussion
Display Last Refresh Date with New Data
No. You have two options:
- Last time it was refreshed - blog here Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics
- Lastest date in your data - so a CALCULATE(MAX(Table[DateValue]), REMOVEFILTERS()) would show this if you have a date column in your fact data.
But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.
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.