Power Bi Service - Excel sheet API

Thankyou, Gabry for your response.

Hi OttoKok6,

We appreciate your enquiry through the Microsoft Fabric Community Forum.

Based on my understanding, the refresh is failing in the Power BI Service because the Web API data source referenced by the Excel connector has not been configured or mapped in the Service. It works in Desktop because the machine has direct access.However, in the Service the dataset requires the Web data source to be registered with the gateway and to have credentials assigned.

Please follow the steps below, which may help resolve the issue:

1. In the Power BI Service, go to Settings and select Manage connections and gateways. Add the Web API endpoint as a Web data source and provide the same authentication method that used in Desktop.
2. In the Workspace, go to Datasets and select Settings. Under Gateway connection, map the dataset’s Web source to the gateway data source created.
3. Under Data source credentials, re-enter the credentials and save.
4. Test using Refresh now, and then enable scheduled refresh.

If the API is publicly accessible, a gateway may not be required. In that case, simply set the correct Data source credentials in the dataset settings.

Additionally, please refer to the following links:
On-premises data gateway - Power BI | Microsoft Learn
Add or remove a gateway data source - Power BI | Microsoft Learn
Power Query Web connector - Power Query | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.