Forum Discussion

PowerTotheDevs's avatar
PowerTotheDevs
Regular Visitor
1 year ago
Solved

Power bi REST API - SP not working

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 c...
  • rohit1991's avatar
    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.