Azure DevOps OData Feed Suddenly Failing in Power BI with ResourceAccessForbiddenException

[yeshwanthi_vadd]

Hi Everyone,

Our Power BI reports connected to Azure DevOps Analytics OData feeds were working correctly until around 3 days ago, and suddenly started failing.

Originally we were using a v3 OData preview endpoint, and after the issue started we migrated to a v4 Analytics endpoint.

The Analytics endpoint works correctly in browser and returns metadata successfully.

However, Power BI Desktop still fails during refresh/load with the following errors:

Error 1:
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

Error 2:
Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException

Affected tables:
- WorkItems
- WorkItemLinks

Things already attempted:
- Migrated from v3 to v4 endpoint
- Cleared Power BI cache
- Removed all data source permissions
- Reauthenticated using Organizational Account
- Recreated queries from scratch
- Restarted Power BI Desktop
- Tested endpoint directly in browser successfully
- Tried both org-level and project-level endpoints

Sample query used:

let
Source = OData.Feed(
"https://analytics.dev.azure.com/<organization>/_odata/v3.0-preview/",
null,
[Implementation="2.0"]
)
in
Source

The issue started suddenly after working for months without problems.

Has anyone experienced recent Azure DevOps Analytics/OData changes or permission-related issues causing this?

Any help would be appreciated.

[KevinChant]

Are you working with just work items in Azure DevOps?

If so, you might be better off working with analytics Views:
About Analytics views - Azure DevOps | Microsoft Learn 

[v-shchada-msft]

Hi @yeshwanthi_vadd,

Just checking in to see if your issue has been resolved. Please let us know if you need any further assistance.

Thank you.

[v-shchada-msft]

Hi @yeshwanthi_vadd,
Thank you for reaching out to the Microsoft Fabric Community Forum.

Just checking in, were you able to resolve the issue? If not please feel free to share an update and we'll be happy to assist further.
Your feedback will also help others facing similar challenges.

Thank you.

[v-shchada-msft]

Hi @yeshwanthi_vadd,
Thank you for posting your query in the Microsoft Fabric Community Forum.

As you have already tried several troubleshooting steps.Please also try testing once with the supported stable endpoint v2.0 instead of the preview versions.

Also, please verify that the account used in Power BI has the required Azure DevOps Analytics permissions such as project access, appropriate access level, and View analytics permission.

Please refer the following Official Microsoft documentations:

Analytics permissions and security - Azure DevOps | Microsoft Learn
OData API versioning - Azure DevOps | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.

Thanks and Regards.

[lbendlin]

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 .