Forum Discussion

RaulSantos's avatar
RaulSantos
Regular Visitor
1 year ago
Solved

Use API to execute query to dataset giving Unauthorized Error

Hello,   I am having troubles trying to execute the following endpoint: https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/executeQueries Body: {   "queries": [     {       "query": "E...
Tutorial Requests
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi RaulSantos ,

    Thank you for reaching out to Microsoft Fabric Community.

    The 401 Unauthorized error likely means the Service Principal lacks access to the specific dataset, even if it works for others in the same workspace. Make sure the SPN has Build or Read permissions directly on the dataset (via Dataset > Settings > Permissions). Also, confirm that Service Principal access is enabled in the Power BI Admin Portal and the SPN is in the allowed security group. Older datasets may have hidden ownership issues - deleting and republishing resets ownership, which is why that workaround helped. Reassigning access or publishing from the SPN should resolve it.

    Thank you.

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi RaulSantos ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

RaulSantos's avatar
RaulSantos
Regular Visitor
1 year ago

Hello v-venuppu 

Thank you for your help in advance

Unfortunately I still didn't have the chance to test it since I was off this 3 days.

 

I'll try to solve it this week.

As soon as I have some feedback I'll put the feedback here 

 

Thank you once again 🙂