Forum Discussion

CrouchingTiger's avatar
CrouchingTiger
Helper I
1 year ago
Solved

Web url refresh error

Hi, expert I have a Power BI report and the data set was from web url(API) with query string. and configure a refresh scedule, 5 times / day(Fig1)   I'm not sure why refresh fialed. mostly 1 out ...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, Akash_Varuna, for your response.

    Hi CrouchingTiger,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Based on my understanding, the error message "DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError" indicates that Power BI was unable to establish a connection to your Web API source within the stipulated time. This is generally a transient network issue and is not due to any fault in the Power BI setup. Such issues can occur when the API server is slow, experiencing high load, temporarily unavailable, or there is network latency between the Power BI Service and the API. Additionally, API throttling or timeouts from the source may also contribute to this error.

    As your refresh operation succeeds most of the time, with a failure occurring only once in eight attempts, occasional failures are to be expected when using external APIs and are not a cause for serious concern.

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other members of the community facing similar issues.

    Thank you.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi CrouchingTiger 

  1. API rate limits: These define how many requests you can make within a specific time. Check the API's documentation or ask the provider for the limits.

  2. Network or Gateway issues: Monitor the gateway status in Power BI Admin Portal and ensure it’s updated. Use a reliable network connection.

  3. Timeout due to data volume: Large data can cause occasional timeouts. Try optimizing queries or reducing the data size fetched.

  4. Check API response times: Use tools like Postman or browser developer tools to measure call duration.

  5. Timeout settings: Adjust the "Command Timeout" in Power Query's data source settings.

CrouchingTiger's avatar
CrouchingTiger
Helper I
1 year ago

Hi, Akash_Varuna  Thank you for your kind explaination

  1. API rate limits: These define how many requests you can make within a specific time. Check the API's documentation or ask the provider for the limits.
    => I can't find any limits for provider documentation 

  2. Network or Gateway issues: Monitor the gateway status in Power BI Admin Portal and ensure it’s updated. Use a reliable network connection.
    => Could you please let me know more specific?(where is PBI admin portal? and how can i find my report?)

  3. Timeout due to data volume: Large data can cause occasional timeouts. Try optimizing queries or reducing the data size fetched.
    => Thank you and data size is not large, 120 records wiht 14 fields per 1 page

  4. Check API response times: Use tools like Postman or browser developer tools to measure call duration.
    => Response times : 600ms (from documentation)

  5. Timeout settings: Adjust the "Command Timeout" in Power Query's data source settings.
    => Could you please let me know more specific? about Power Query's data source settings