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

Подписаться 11 тыс.

Просмотров 21 тыс.

50% 1

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.
• Dataset Refresh Report... .
Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
/ power-bi-helpline-22a2...
Email- info@pbihelpline.com
@PowerBIHelpline

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@vaishnavibhadrashette7046 Год назад

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?

@PowerBIHelpline Год назад

Yes this is possible, but you should note that, API refreshes as well are limited to the number of daily refreshes available for your dataset in that particular workspace.

@nehagulhane_26 Месяц назад

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?

@study-biz-hub 2 месяца назад

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

@PowerBIHelpline 2 месяца назад

There are REST APIs already available for such usecases. you may need to use more than 1 API step by step. Please checkout Microsoft official documentation about Power BI Rest APIs

@gurup5474 Месяц назад

@@PowerBIHelpline can you please make one more video for that?? Because I have almost 20 workspace with 1000 reports. in daily bases i have been check all report whether they got refresh successfully or not. so that i can give refresh status to my TL. it took 2 hours every day. so i want to make it simple. please make one more video for that. it would be very very helpful.

@rohithgampa9683 6 дней назад

@@gurup5474 have you got this solution for this

@marcbever1985 Год назад

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

@PowerBIHelpline Год назад

Thanks for the appreciations. Are you using Power automate as well? you can try adding the service principal as one of the Admin of the Power BI workspace (the workspace which hosts your Power Bi dataset). Yes Permissions need to be granted from azure portal as shown in the video.

@marcbever1985 Год назад

@@PowerBIHelpline thanks for your swift reaction. We plan to use a logic app in azure which mostly is the same as power automate. For now I work with a python script to test. The one thing I noticed is that in your API permissions the statuses are all 'granted', mine are blank. My best guess is that this is the issue. I'm gonna look into this with the azure tenant admin.

@meierthomas 2 месяца назад

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?

@PowerBIHelpline 2 месяца назад

For that you can add a Power automate Button on your report which is configured to refresh the published report once clicked

@nikhiljoshi3750 7 месяцев назад

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

@PowerBIHelpline 7 месяцев назад

This Particular operation is to get the execution details of an "enhanced refresh operation" for the specified dataset from the specified workspace. Please check Documentation about "Enhanced Refresh "

@nishantkumar9570 Год назад

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

@PowerBIHelpline Год назад

Yes HTTP is a premium connector. and you need a Pro or PPU license to call RestAPI

@nishantkumar9570 Год назад

@@PowerBIHelpline Thank You, When I try to embed Power BI content for customers it's asking I need capacity, Do you have any idea?

@PowerBIHelpline Год назад

Yes Embedding requires Premium or an Azure capacity, you still need a Pro or PPU license to call the APIs. in case of new Fabric capacity it is a little different. you should checkout the official documentation about Power BI Embedded.

@AnnaTan-f1x Год назад

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

@PowerBIHelpline Год назад

this method fetches refresh history page from Power BI service, and it should show the scheduled refreshes, but to show the next schedule refresh, i don't think there is an API available for now

@rohithgampa9683 6 дней назад

Could you please let us know if we have 30 data sets and different workspaces kindly help

@PowerBIHelpline 5 дней назад

Yes, there are Power bi Rest APIs available for this as well. you may need to combine 2 APIs in steps.

@adamreguig7650 Год назад

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

@PowerBIHelpline Год назад

Dataset refreshes from a shared/pro workspace is limited to 8 refreshes per day including scheduled refreshes. For Premium capacity, it depend upon the available resources.

@PrathmeshMutha Год назад

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

@PowerBIHelpline Год назад

There are multiple APIs available on that same page for each different purpose including yours. you can utilize the same. remaining process will be same.

@prathmeshmutha4554 Год назад

@@PowerBIHelpline Can you please name the API??

@PowerBIHelpline Год назад

@@prathmeshmutha4554 basically, you need to use the API to get All datasets first, and then you need to create the loop to run through each datset's refresh history from your application. you can also do that with power automate, but you need to add those additional steps for iterations.

@tigitang8719 Год назад

Thank you for providing this video. As a newcomer to Power Automate, I'd greatly appreciate it if you could create a video that addresses multiple datasets within a single workspace and multiple datasets from multiple workspaces. Thank you in advance!@@PowerBIHelpline

@tranceinpeace 9 месяцев назад

@@PowerBIHelplinethanks for the wonderful concept It would be grateful if you do a video on getting refresh status of all datasets present in one workspace . Thanks in advance 🎉🎉🎉

@rihamfathy3521 6 месяцев назад

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

@PowerBIHelpline 6 месяцев назад

once you register the App you will get it as shown in the video.

@rihamfathy3521 6 месяцев назад

Yes I got it. I have an issue now I made all the steps in the video but I want to use POST request not GET request, I need to cancel a power running data flow but I have error 403 user is not authorised what should I do to fix thix

@PowerBIHelpline 6 месяцев назад

@@rihamfathy3521 Add the Service principal as an Admin to the workspace where you have that dataflow. it should work.

@rihamfathy3521 6 месяцев назад

You means to add the application name I created on azure to be admin to the workspace, I did so

@rihamfathy3521 6 месяцев назад

@NicolasLeJeune 10 месяцев назад

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

@nehagulhane_26 Месяц назад

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?