Forum Discussion
PowerBINotAuthorizedException when trying to use ExecuteQueries endpoint
Hello! I am trying to use the ExecuteQueries endpoint of the PowerBI API in order to execute some DAX, but for this specific dataset and workspace combination, I am getting a 401 PowerBINotAuthorized...
I managed to find why this does not work. It is because the ExecuteQueries API endpoints does not work on datasets using RLS.
To be clear, that is only a limitation for the Service Principal - for quite obvious reasons.
Limitations
- Only datasets in a new workspace experience workspace, that is to say a V2 workspace, are supported.
- Datasets that are hosted in Azure Analysis Services or that have a live connection to an on-premises Azure Analysis Services model aren't supported.
- The tenant setting Allow XMLA endpoints and Analyze in Excel with on-premises datasets must be enabled.
- One query per API call.
- One table request per query.
- Maximum of 100,000 table rows per query.
- Service Principals aren't supported for datasets with RLS per RLS limitations and user impersonation isn't supported.