Hi @lisha ,
I'm using a flow to check if my Power BI Dataset was updated today. Power Automate then returns me the timestamp of the latest Dataset refresh and pushes it to me via Teams or E-Mail.
However, you can also just use the timestamp inside your flow to run checks and maybe abort the flow if the Dataset refresh failed.
To get this working you need to follow these steps in your Power BI Datamodel that you want to get the latest refresh date from:
1. Open your Power BI Data Model and
2. Open the Power Query Editor (Transform Data Button in the header nav of Power BI)
3. Create a new "Blank Query" and insert the following code
let Source = DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())
in Source
4. This will return a timestamp of the latest refresh of the datamodel
I named everything as the following screenshot shows:
After you completed the above steps we switch to Power Automate for the following steps:
1. Insert a Query on a Power BI DataSet
a) Select the workspace of your DataSet
b) Select your DataSet
c) Enter the following DAX Query to get last refresh value
// DAX Query
DEFINE
VAR __DS0Core =
DISTINCT('latest_refresh'[latest_refresh])
VAR __DS0PrimaryWindowed =
TOPN(501, __DS0Core, 'latest_refresh'[latest_refresh], 0)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
'latest_refresh'[latest_refresh] DESC
2. Continue with your flow 🙂
It's useful to add a separate Query on your Dataset to get the last_refresh data as it might return some errors .
