Forum Discussion
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 refreshes are failing. Any idea on how I might resolve this or what is causing the problem:
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:
- Retry the refresh manually in Power BI Service.
- Check the data source credentials in the dataset settings.
- Test the OData feed URL (https://analytics.dev.azure.com/...) in a browser or Power BI Desktop to confirm it's accessible.
- Review Azure DevOps API limits or recent changes in access policies.
- 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 🌀.
4 Replies
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:
- Retry the refresh manually in Power BI Service.
- Check the data source credentials in the dataset settings.
- Test the OData feed URL (https://analytics.dev.azure.com/...) in a browser or Power BI Desktop to confirm it's accessible.
- Review Azure DevOps API limits or recent changes in access policies.
- 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 🌀.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .Hi Russo ,
Thank you lbendlin , Zanqueta for your inputs.We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.I checked steps 1-4 and were already good. I did a manual refresh and refreshed my credentials which I had tried before but maybe attributed to the fixed this time.. Coicidentally, after ten days I am no longer getting the issue. If the issue comes back, my plan is to submit a ticket to Microsoft.
