Get latest refresh time from PowerBI.com and use it Power Automate

[Lorentzen]

Hi guys.

This question is probably in the space between PowerBI and Power Automate since I am building a flow that needs to do the following:

Step 1 Trigger: When a new row is added in a sql table, the trigger needs to start.
Step 2 Action: Update a specific table in SQL with Start datetime.
Step 3 Action: When table is succesfully updated - refresh the PowerBI report
Step 4 Action: When PowerBI report is done updating - update the same specific table with End datetime.
Step 5 Action: Send an Email (on succes and on failure)

All of this has been done and it works. Now here is my challenge:

Power Automate reports back to me, that this flow takes 2 seconds every morning.
On PowerBI.com i see that it takes around 10 minutes to refresh the PowerBI Report.

This means that the flow updates my sql table with the wrong "End datetime". 
I can not use the duration, which i need to be able to monitor my powerbi reports.
I want the endtime from PowerBI.com. How???

I have searched the internet, and found the following:

https://powerfulbi.co.uk/powerbi-status-with-powerautomate-refresh-all-in-one-powerapp/

Unfortunately in his step 2 "Create custom connecter" his link does not work. 

So to be very clear:

In my PowerAutomate i need to pull in the latest refresh time (maybe with an API) from Powerbi.com and use that timestamp to update my endtime in my sql table 

This is my flow without the details. In the scope i have my "PowerBI refresh dashboards".

[lbendlin]

What you do in Power Automate is not to run a Power BI dataset refresh.  What you do is request a refresh to be started. That request is a quick (2 s) API call.  What you really need to do is wait for the refresh to complete.  That includes polling the refresh history and checking if the latest entry has an end date.

By the way, hot off the press: Enhanced refresh with the Power BI REST API is now generally available | Microsoft Power BI Blog | M...