topic Re: 401 Error on executeQueries API Call – Suspected Configuration Change in Developer

401 Error on executeQueries API Call – Suspected Configuration Change

jay-sr — Tue, 25 Mar 2025 07:27:29 GMT

Hello Power BI Community,

I'm experiencing an issue with the executeQueries endpoint in the Power BI REST API. My application successfully retrieves an auth token, which appears to be valid, but when I call executeQueries, I receive a 401 Unauthorized error. This functionality was working fine previously, and I haven't made any code changes.

Here are the details I've verified so far:

Auth Token: Obtained successfully with the correct audience (https://login.microsoftonline.com/${tenantId}/oauth2/v2.0/token) and expected scopes.
Authorization Header: I'm including the header as Authorization: Bearer my_token.
App Registration & Permissions: The app registration in Azure AD has the necessary API permissions (such as "roles": ["Tenant.Read.All"],), and I've ensured that admin consent is in place.
Recent Changes: There haven't been any changes on the code side; I'm wondering if a recent configuration update or policy change on the Power BI service or within my tenant might be affecting this API call.

Has anyone else encountered this issue recently, or does anyone have insights into possible configuration changes that could cause a 401 error on executeQueries? Any troubleshooting tips or guidance would be greatly appreciated.

Thank you in advance for your help!

Re: 401 Error on executeQueries API Call – Suspected Configuration Change

Deku — Tue, 25 Mar 2025 17:02:45 GMT

Has the SPN permissions on the workspace or dataset changed?

Try calling get datasets in group or something to test if it is just API.

Are you calling DMV or info functions?

Re: 401 Error on executeQueries API Call – Suspected Configuration Change

Anonymous — Tue, 01 Apr 2025 04:08:39 GMT

Hi @jay-sr ,
Thank you @Deku for the prompt response!

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.

Re: 401 Error on executeQueries API Call – Suspected Configuration Change

Anonymous — Thu, 03 Apr 2025 12:32:32 GMT

Hi @jay-sr ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

Re: 401 Error on executeQueries API Call – Suspected Configuration Change

Anonymous — Mon, 07 Apr 2025 12:20:43 GMT

Hi @jay-sr ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question

Thank you.