Forum Discussion

Flueron's avatar
Flueron
New Member
6 months ago
Solved

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

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 ...
Need Help
  • v-achippa's avatar
    v-achippa
    6 months ago

    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's avatar
v-achippa
Community Support
6 months ago

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's avatar
v-achippa
Community Support
6 months ago

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