topic Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate in Developer

Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

Amar_vm — Sat, 02 Dec 2023 00:34:24 GMT

Used the HTTP action to invoke an Power BI Rest API for updating parameters of a particular dataset in a workspace but keep getting the 401/403 error codes while trying to run the flow. Tried do this same action in Power Shell as well using Power BI cmdlet but getting the same error codes, any help on how to tackle these errors or any better way to automatically update parameters in a Power BI report are helpful. Thank you.

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

lbendlin — Mon, 11 Dec 2023 02:18:56 GMT

Try the call in the API sandbox

Datasets - Update Parameters In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

Amar_vm — Mon, 11 Dec 2023 17:11:56 GMT

Tried an example over there and the API call went through without error, but getting the 403 error in Power Automate. The user is the dataset owner in both the cases.

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

lbendlin — Mon, 11 Dec 2023 18:57:53 GMT

dataset owner may not be enough. That call may require workspace level permissions.

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

Amar_vm — Thu, 14 Dec 2023 19:25:04 GMT

How do we check and edit those permissions? Currently using an embeded app created in Azure AD for the API is there some other way?

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

lbendlin — Thu, 14 Dec 2023 19:28:36 GMT

you can check the token scope with jwt.io but I don't think that's the issue.

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

Anonymous — Mon, 08 Jan 2024 08:53:12 GMT

Hi @Amar_vm ,

This is a Power BI Rest API issue, not a Mobile App issue, next time if you encounter such a problem, please feel free to ask in the Developer forum, thank you!

If you post in the right forum, it will help you to get the solution quickly.

I have forwarded this post to Developer Forum, please know.

According to my research and understanding, 401/403 related error return codes are usually related to insufficient privileges or disabled admin settings, if it's convenient can you show how the AAD token is generated for you to run this rest API? If it is generated by AAD user, it should only need dataset owner permission, if it is called by a service principal profile, it may need more settings and permissions, you also need to open some admin settings, you can refer to this document

Embed Power BI content in an embedded analytics application with service principal and an application secret - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Encountering 401/403 errors while using the Power BI REST API with PowerShell and Power Automate

lbendlin — Wed, 10 Jan 2024 23:10:35 GMT

Does it work in the API sandbox?

Datasets - Update Parameters - REST API (Power BI Power BI REST APIs) | Microsoft Learn