Forum Discussion
Power bi REST API - SP not working
- 1 year ago
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.
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.