Error: {'error': {'code': 'PowerBINotAuthorizedException' when calling executeQueries API

[pennyhoho117]

Hi ,

i am now stuck in a error when calling power bi API: https://api.powerbi.com/v1.0/myorg/groups/xxxxx/datasets/xx/executeQueries.

i have two datasets A and B in same workspace.

i call the API ,

https://api.powerbi.com/v1.0/myorg/groups/xxxxx/datasets/A/executeQueries.

and https://api.powerbi.com/v1.0/myorg/groups/xxxxx/datasets/B/executeQueries.

with query: "EVALUATE ROW(\"currentDate\", TODAY())" respectively.

one success but one failed with error: 

{'error': {'code': 'PowerBINotAuthorizedException', 'pbi.error': {'code': 'PowerBINotAuthorizedException', 'parameters': {}, 'details': [], 'exceptionCulprit': 1}}}

Can anyone give me some suggestions for the root cause?

Thanks

[Anonymous]

Hi @pennyhoho117 ,

Base on your description, it seems you got the error when calling executeQueries API for one of datasets in the same workspace. One can work, the other one get PowerBINotAuthorizedException error. The following thread is the one which has the similar problem as yours, hope its solution can help you solve the problem.

Solved: PowerBI API Returns "PowerBINotAuthorizedException... - Microsoft Fabric Community

When you use the admin api you need to grant access to this in the tenant admin. Because you use service principal this need to be added in a security group, and this group needs to be granted admin api access in the tenant admin portal.

When this is done, I,ve experienced it can take up to 20-30 min before it works.

---

Best Regards