Forum Discussion

AshtonDeLano's avatar
AshtonDeLano
Frequent Visitor
2 years ago

Can refresh dataset in app.powerbi.com but cannot execute queries against it

 

I am trying to execute a query to get a table out of a dataset using Azure Data Factory web activity. I am using the following documentation:

 

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group

 

The following API call:

 

 

POST https://api.powerbi.com/v1.0/myorg/groups/{groupID}/datasets/{datasetID}/executeQueries/


Body: {
"queries": [
{
"query": "EVALUATE VALUES('{table name}')"
}
],
"serializerSettings": {
"includeNulls": true
},
"impersonatedUserName": {[email protected]}
}


Authentication: System Assigned Managed Identity

Resource: https://analysis.windows.net/powerbi/api

 

 

 

Returns the following error: {"error":{"code":"PowerBINotAuthorizedException","pbi.error":{"code":"PowerBINotAuthorizedException","parameters":{},"details":[],"exceptionCulprit":1}}}

 

However, the API call below does execute successfully:

 

 

 

POST https://api.powerbi.com/v1.0/myorg/groups/{groupID}/datasets/{datasetID}/refreshes/

body: {
"retryCount": 0
}

Authentication: System Assigned Managed Identity

Resource: https://analysis.windows.net/powerbi/api

 

 

 

As far as I am aware, I have enabled all necessary permissions in the admin portal of app.powerbi.com. If the POST call to refresh a dataset is working, I do not know why the executeQueries API call is not working.

 

Is there something I am missing about permissions in the workspace in app.powerbi.com?

 

 

 

2 Replies

  • Do you have "Build"  permissions against the semantic model?

    • AshtonDeLano's avatar
      AshtonDeLano
      Frequent Visitor

      Yes. Both the Data Factory and the impersonatedUserName have Workspace Admin and All Permissions Granted.