Forum Discussion

Russo's avatar
Russo
Helper I
8 months ago
Solved

Refresh fail due to DataSource error OData

Hi community -  I have a med-large report with a few various connections e.g., Sharepoint files, OData from Azure Devop.  I'm all of the sudden getting this error message saying that my auto refresh...
  • Zanqueta's avatar
    8 months ago

    Hi Russo,

     

    This error typically indicates that the remote server (Azure DevOps in this case) is terminating the connection unexpectedly. This is often a transient issue, but if it persists, it may require further investigation.

     

    In your shoes, I gonna try:

     

    1. Retry the refresh manually in Power BI Service.
    2. Check the data source credentials in the dataset settings.
    3. Test the OData feed URL (https://analytics.dev.azure.com/...) in a browser or Power BI Desktop to confirm it's accessible.
    4. Review Azure DevOps API limits or recent changes in access policies.
    5. Contact Microsoft Support if the issue persists, especially if the error continues across multiple refresh attempts.

     

    An extra advise:

    Authentication or Token Expiry:

    • Cause: If using organisational accounts or OAuth, tokens may expire or permissions may change.
    • Action:
      • Re-authenticate the OData connection in Power BI Service.
      • Go to Settings > Datasets > Data source credentials and re-enter credentials.

     

    Documentation: Troubleshoot refresh scenarios - Power BI | Microsoft Learn

     

    If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

    Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.