Dataset Refresh Report with Power BI Rest API and Power Automate | Track all your refresh Status
Вставка
- Опубліковано 11 вер 2024
- 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
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?
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
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.
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
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
@@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.
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?
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.
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
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.
@@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.
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?
For that you can add a Power automate Button on your report which is configured to refresh the published report once clicked
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
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 "
Hi, I would like to have the next scheduled refresh time shown on my PBI report. Is it possible to help me? Thanks,
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
I have multiple datasets in my workspace then how can I track all of them? And create a tracking report
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.
@@PowerBIHelpline Can you please name the API??
@@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.
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
@@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 🎉🎉🎉
What license we need to call the Power BI RestAPI?
And HTTP is power automate premium connector right?
Yes HTTP is a premium connector. and you need a Pro or PPU license to call RestAPI
@@PowerBIHelpline Thank You, When I try to embed Power BI content for customers it's asking I need capacity, Do you have any idea?
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.
Be mindfull that this require a premium licence of Power automate for the http and json parsing steps :(
from where can i get the filed secret in the html action
once you register the App you will get it as shown in the video.
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
@@rihamfathy3521 Add the Service principal as an Admin to the workspace where you have that dataflow. it should work.
You means to add the application name I created on azure to be admin to the workspace, I did so
؟
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?