Power BI Report based on the dataset refresh data

[Anonymous]

Hello ,

I am trying to create a  power BI dashboard where I can show all existing prod dataset refresh status to higher management. For that I am using Microsoft flow to bring the dataset refresh history on timely .

Now here I am able to create a Microsoft flow to bring the refresh history data but not able to save the flow job result which in to excel file .

Any one created the dataset refresh status dashboard on power BI. If yes kindly advise me.

[v-juanli-msft]

Hi @Anonymous 

You can find a link to display the refresh history in the dataset settings. You can also retrieve the refresh history programmatically by using the Power BI REST API. By using a custom solution, you can monitor the refresh history of multiple datasets in a centralized way.

https://docs.microsoft.com/en-us/power-bi/refresh-data#configure-scheduled-refresh

Best Regards

Maggie

Community Support Team _ Maggie Li

[Anonymous]

Could you please share the API setup setps . Its really helpfull to me. 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

In this link,

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup

click on the "try it", on the right window, provide the "group id"(workspace id), datatset id, click "run",

then copy the url (after "Get") in the "Url" box in Power BI (Get daata->Web connector->Advanced)

copy the code (after "Authorization") in the box in Power BI as i lined.

Then select the correct credential in the pop-out window to connect to the data source,

if all above are successful, then in edit queries, click on the "list"->"convert it to table"-"expand"

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bdavison]

Hi @v-juanli-msft (or anyone else who can help)

The above seems to work fine, but i'm having an issue with the Authorization token.  

I'd like this to work each time the dataset is refreshed, but after setting this up the Authorization token is only valid for 1 hour.  

It expires after an hour and i've seen that you need to update the 

The solution seems to be setting up the initial call to 

https://login.microsoftonline.com/[tenant_id]/oauth2/token/ to get a refresh token.  

which is then used.  can you provide any guidance on setting up the refresh token needed here

[Anonymous]

Thanks for your solution .. its worked for me..

How to manage the relationship if i would like to pull multiple dataset history . 

Would like to show Overall success percentage for all the reports.