Forum Discussion

Chief's avatar
Chief
Helper II
1 year ago
Solved

Help: Web API works in Desktop but disconnected in Service

Hello, I have a report that I have created in desktop that uses two connections to the data. The first via an ODBC connection and the second through a web API. When I refresh the data, everything wo...
Need Help
  • v-prasare's avatar
    v-prasare
    11 months ago

    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

     

GilbertQ's avatar
GilbertQ
Super User
1 year ago

Hi Chief 

 

As far as I am aware, if you are using an ODBC connection you will need to use a gateway to authenticate. Quite often what happens is when you have two different data connections, both of them will have to go through the gateway. So what you'll need to do is in the Power BI service you will have to create a new API/Web connection that will then go via your gateway. Add or remove a gateway data source - Power BI | Microsoft Learn

Chief's avatar
Chief
Helper II
1 year ago

thanks for the response. When estabilishing on premis data gateway test connection fails to authenticate. I've tried Anonymous, Basic, etc. but none will allow connection. Result is: credentials provided for the source are invalid. I'm not sure what credentials they are looking for, my standard username and password to log into the web application or something else. Nothing seems to work.