Forum Discussion
Helper IIAccess to the resource is forbidden
Super UserHi SureshA
Try the following steps to resolve it:
1/Check your VPN connection:
Make sure your VPN connection is stable. Connection drops or configuration changes in the VPN can cause “Access to the resource is forbidden” errors.2/Try without VPN:
If possible, disconnect from the VPN and refresh your Power BI or Excel data. If it works without VPN, then the issue is likely caused by the VPN configuration or restrictions.3/Review firewall or network restrictions:
Some VPNs apply firewall rules that block certain URLs or ports. Ensure that your VPN or network allows access to Azure DevOps and its OData endpoints.4/Refresh your credentials:
Re-enter or update your login credentials in Power BI and Excel after connecting through the VPN. Authentication tokens may not pass correctly over some VPN connections.5/Contact your IT or VPN administrator:
If your organization manages the VPN, ask the network team to check whether traffic to Azure DevOps OData services is being restricted.
Helper III 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-ssriganeshCommunity Support
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.