Forum Discussion

SureshA's avatar
SureshA
Icon for Helper II rankHelper II
1 year ago

Access to the resource is forbidden

I have built dashboard in powerbi using ADO analytics views and in excel to  ADO using OData power query  I have the required permission to ado projects and able to get dataset in both powerbi and e...
Need Help
SureshA's avatar
SureshA
Icon for Helper II rankHelper II
11 months ago

I have been using odata to get data from ado in excel. But the error keeps coming when i close and reopen the excel fike. Despite clearing permissions and relogging to ado this error comes and upsets the data refresh and im unable to share thr excel output to mgmt since they too will get same error

Tried to open disconnecting to vpn doesnt help either

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
11 months ago

Hello SureshA,
From your description, it appears that the issue is occurring only with the Excel OData connection to Azure DevOps, while your Power BI connection continues to work fine.

Since this behavior is specific to Excel’s OData authentication and refresh, we recommend posting your question in the Microsoft Excel Community: https://techcommunity.microsoft.com/category/microsoft365/discussions/excelgeneral

for targeted assistance the experts there can provide guidance specific to Excel’s connection and credential caching behavior.