Forum Discussion

Prakash1050's avatar
Prakash1050
Helper III
1 year ago
Solved

Power Automate - REST API

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,
 
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.
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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!!

     

3 Replies

  • Poojara_D12's avatar
    Poojara_D12
    Super User
    1 year ago

    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's avatar
      Prakash1050
      Helper III
      1 year ago

      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.