Super User
Helper IIThe limit of this method is when you or your user refresh the navigator, it changes.
I mean for instance, you planed to put the refresh for instane eveyy 1 hour let's say at 7h AM, 8AM, and 9 AM
The user consults the report at 2 PM and refresh, in this case, the last refresh date is 2PM, it is not the cas.
I explored a vue using this SQL in M code
SELECT LAST_DATA_UPDATE FROM $SYSTEM_MDSCHEMA_CUBES
The limits of this one is : if your workspace is not premium, so it's not working and also, there will be some delta between the true last refresh succed and this LAST_DATA_UPDATE FROM
**** The geat solution****
Data scrapping
in the workspace, in parameter and in refesh history, there are some metadata so you just take the last one where the status is succed.
To do this,
-1 using python to write script, and call it in your M code (manual)
-2 using python script and make an azure function (100% cloud) and call it in M code
3- Power Automate, this is one ot the best solution I think