Power Automate - REST API

[Prakash1050]

Hi All,

I need to get refresh history of my Power Dataset using Power automate HTTP request via Azure Active Directory OAuth.

I complete all the Process in Azure Portal like, Register Application to get required IDs, Give API Permission for dataset Dataset.Read.All and in HTTP URL give group id and dataset id from the dataset.

This Process all are complete with the help by the below video,

https://www.youtube.com/watch?v=PVpfKNPsafI  -  till 13:30 mins.

But I got the error : Unauthorized.

I don't have any license for Power automate. Is it Problem for this?
I have Trial Environment and Public API is working is fine. But, here got this error.

How to resolve this? 

Please help me.

Thanks in advance.

[Poojara_D12 · Accepted solution]

Hi @Prakash1050 

The "Unauthorized" error you're seeing is likely due to missing or incorrect permissions related to your Azure Active Directory (AAD) app, not having the right Power BI license, or incorrect OAuth authentication.

• Power Automate requires either a Power BI Pro or Premium Per User (PPU) license to access Power BI API resources.
• A trial environment without the correct license may cause this issue, especially if you're trying to interact with datasets in the Power BI Service.
• Also, Ensure that your AAD app has Dataset.Read.All permission under API Permissions in the Azure Portal.
• After assigning the permissions, don’t forget to Grant Admin Consent for those permissions in the Azure Portal.
• If you’re missing the Power BI Pro license or don't have the right permissions in the workspace, those will cause authorization issues.
• You'll need to get the appropriate license and verify the permission setup in Azure AD.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS  (360 remaining for 500 SUBS) Please support!!

[Prakash1050]

Hi @Poojara_D12 ,

Thanks for you reply. Now the error is gone when I give admin API Permission in Azure Portal and enable all API option in Power BI - Tenant Setting.

[Poojara_D12]

Glad to hear that!! 🙂