Dataset access through REST API without workspace access

[niranjanbn19]

Hi, I want to execute queries on a dataset using REST APIs but I don't have workspace permissions. Can I execute queries using REST APIs how I am doing it on PowerBI desktop and refresh the dataset in browser? 

I got 401 with PowerBINotAuthorizedException when I tried to get a dataset using below endpoint. But getting information about the refresh.Please let me know if I can use any other endpoint or I am missing any permissions.

Not working: https://api.powerbi.com/v1.0/myorg/groups/{groupid}/datasets/{datasetid}

Working: https://api.powerbi.com/v1.0/myorg/groups/{groupid}/datasets/{datasetid}/refreshes?$top=10

[v-yangliu-msft · Accepted solution]

Hi  @niranjanbn19 ,

Restrictions according to the official documentation:

The user must have Manage dataset access permissions.

Refer to：

Datasets - Execute Queries In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If you don't have workspace permissions, you can try giving user permissions in dataset.

Manage dataset access permissions - 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.