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": {myAdmin@Email.com}
}
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?
