search

migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API
MIT License
238 stars 74 forks source link

Tables return errors when accessed as admin user #155

Closed 360d-io-labs closed 1 year ago

360d-io-labs commented 1 year ago

All tables except the "Power BI Service Administrator" tables report an error when accessed as an admin user but are working ok when accessed as a normal user.

For instance, when trying to access workspaces table as a PBI admin I get the following error:

Expression.Error: The column 'Column1' of the table wasn't found.
Details:
    Column1

Is this behavior expected? (Admin can only access admin tables) or is it an issue with what is now returned by the API?

klinejordan commented 1 year ago

If the account is only a Tenant Admin and isn't actually a member of any workspaces or an admin of any gateways, it's expected behavior. The non-admin tables only return data for workspaces the calling user is a member of