Power bi REST API - SP not working

[PowerTotheDevs]

Hi there,

I want to use this REST API endpoint:
Items - List Paginated Reports - REST API (PaginatedReport) | Microsoft Learn

I'm using a service principal (app_registration), and i get the correct token and got the right permissions. I can call other power bi rest API's and those works (with the service principal ) - but not the paginated reports ones.

Things i did:

- Power bi admin settings > developer FABRIC service principals turned on

- Service principal itself + the AAD group assigned to the workspace.

- Assigned the delegated permissions - Workspace.Read.All or Workspace.ReadWrite.All

Getting error in my request 400:

"errorCode":"PrincipalTypeNotSupported","message":"The operation is not supported for the principal type"

This while the docs are saying: service principal are supported.

Other things i tried:

- assigned premium capacity (fabric f1 and f2) - but still getting a 400 with the error description.

- when i use a PPU user account (instead of service principal) it works and i'm getting a 200 OK

[Anonymous]

HI @PowerTotheDevs,

Any update on this? Can you please share some more detail information about this?

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @PowerTotheDevs,

What type of service principal are you worked? The default 'client secret' or attached other type of 'certificates' files and invoke based on service principal? Please share some more detail information about this issue amd they should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regads,

Xiaoxin Sheng

[PowerTotheDevs]

Thank you for your answer!

Still a bit strange, then i would need to use a user-based auth in my pipelines, with MFA...

I think it should be possible, because for embedded purposes its also possible.

[rohit1991 · Accepted solution]

Hi @PowerTotheDevsThe issue occurs because the Power BI REST API does not fully support Service Principals for paginated report endpoints, despite what the documentation states. The error "PrincipalTypeNotSupported" suggests that the API requires user-based authentication (delegated permissions) instead of a Service Principal. Your test with a PPU user account working confirms this limitation. Even though you assigned the correct permissions (Workspace.Read.All, Workspace.ReadWrite.All), paginated reports require user-based authentication. To resolve this, try using a user account with delegated permissions instead of a Service Principal, or check if Microsoft has updated API support for this scenario.