Power BI Service Refresh Fails for Web API (Works in Desktop)

[Flueron]

Dear Microsoft Support Team,

I am facing an issue with dataset refresh in Power BI Service.

I am connecting to the following Web API endpoint:
https://www3.tcsion.com/iONBizServices/iONWebService

The API works perfectly in Power BI Desktop using Anonymous authentication. However, after publishing the report to Power BI Service (India Central cluster), the scheduled refresh fails with the below error:

“The credentials provided for the Web source are invalid.”

I have already:

• Verified that authentication type is set to Anonymous in Service.

• Re-entered the credentials in Dataset Settings.

• Confirmed that the API URL works directly in the browser.

Since the same configuration works in Desktop but fails in Service, I would like to confirm:

1. Could this be related to Power BI Service outbound IP restrictions?

2. Do I need to configure an On-Premises Data Gateway for this public API?

3. Is there any known limitation when using Anonymous authentication for Web APIs in Power BI Service?

Cluster URI:
WABI-INDIA-CENTRAL-A-PRIMARY

Please guide me on the correct configuration to enable scheduled refresh in Power BI Service.

Thanks & Regards,
Umesh

[v-achippa · Accepted solution]

Hi @Flueron,

Thank you for reaching out to Microsoft Fabric Community.

Since the API works in desktop but fails in service with Anonymous authentication, this is most commonly caused by IP restrictions on the API side. Power bi service refresh runs from microsoft’s cloud infrastructure, not from your local machine. If the API is restricted to specific IP ranges, the service refresh will fail even though it works in desktop.

Please check with the API provider whether the power bi service outbound IP addresses need to be whitelisted.

A gateway is not required for public API unless there are network restrictions.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Flueron,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Flueron,

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa