Help: Web API works in Desktop but disconnected in Service

Hi Chief,

the first step is to create a free Azure account at https://azure.microsoft.com/free.

Once signed in, they should go to the Azure portal and register a new app under Azure Active Directory > App registrations and name the app (e.g., “PowerBI_API_App”), choose “Single tenant,”. After registering, generate a client secret under “Certificates & secrets” and copy the value immediately, as it won’t be shown again.

Next, assign API permissions to the app by going to “API permissions,” selecting “Power BI Service,” and adding delegated permissions like Dataset.Read.All, Report.Read.All, and Workspace.Read.All. Admin consent must be granted for these permissions to take effect.

Then, in the Power BI Admin Portal (https://app.powerbi.com/admin-portal), enable tenant settings to allow service principals to use Power BI APIs and access workspaces. Finally, go to the Power BI workspace, click “Access,” and add the registered app (service principal) with a role like Member or Admin.

This setup allows Power BI Service to authenticate securely using the app instead of relying on unsupported API key headers.

Hope above setup resolves your query and with little research you will be able overcome permission issues in your usecase mentioned above

Thanks,

Prashanth Are

MS fabric community support