Dataset Refresh Report with Power BI Rest API and Power Automate | Track all your refresh Status

By default, we get only refresh failure notification. But Many Times we get requirements to create a report which can track all the dataset refresh history. In this video, we will show you a quick workaround to get Refresh Success notification, and then we will use Power BI rest API and Power Automate to create the Refresh history report of a Power BI dataset. You will get to know about power BI Embedded techniques as well in this video.


Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric

Follow us on LinkedIn
@PowerBIHelpline

[nehagulhane_]

My Flow fails with unauthorised error for the Audience url.. what correct value should be passed here? Any value from 'Expose an API' under Azure Active Directory?

[vaishnavibhadrashette]

Hi, first of all very insightful video, thanks for that.
A doubt, I have a use case I'm calling refresh post api to actually refresh my data. I want my microservice to get notified as soon as refresh status complete.
So is there any solution around that?

[marcbever]

Hi, great videos! Very instructive and a good pace! Regarding youw example in this video; I tried to reproduce 1-on-1 but keep getting 401 error. We are working with Pro workspaces. We get an access token when performing the request but then > 401. Are there any aspects in the app permisions I should be mindful of, or do I still need to login with my user account before making the api call? regards

[study-biz-hub]

Thanks for your video! But I have 1 question: If I have a lot of report in my workspace and I want to monitor all historical status of them, how can I do it? Because I see we input the group_id and dataset_id, with 1 report just has 1 dataset_id

[adamreguig]

hi, do you know how many times a day you can refresh a dataflow using the api when you have a pro account?

btw very good video

[meierthomas]

So I have a power bi report user. If this report user clicks refresh, would it be possible to trigger the API to put updated data down to the report?

[nikhiljoshi]

We are trying to see the dataset refresh Execution details. When the dataset refresh is undergoing refresh, gor this requirement we need 2 parameters

1) Dataset ID
2) Refresh ID
Dataset id we are able to find from the url but we are not able to find refresh id, can you please help us in finding refresh id and also make a video on this requirement

[AnnaTan-fx]

Hi, I would like to have the next scheduled refresh time shown on my PBI report. Is it possible to help me? Thanks,

[nishantkumar]

What license we need to call the Power BI RestAPI?
And HTTP is power automate premium connector right?

[PrathmeshMutha]

I have multiple datasets in my workspace then how can I track all of them? And create a tracking report

[rihamfathy]

from where can i get the filed secret in the html action

[NicolasLeJeune]

Be mindfull that this require a premium licence of Power automate for the http and json parsing steps :(

[nehagulhane_]

My Flow fails with unauthorised error for the Audience url.. what correct value should be passed here? Any value from 'Expose an API' under Azure Active Directory?