Forum Discussion
Power BI Desktop - Expression.Error: Expression.Error: Access to the resource is forbidden
Hello,
we have a Datafow Gen1 set up in Power BI Service. Differnet Workspaces with Dataflows holding Data. Al within Pro Workspaces and licensing.
We build reports in Power BI Desktop using those dataflows as datasource, all working fine.
Suddenly we are no longer able to retrieve the data of the dataflows in power bi desktop. In the get data navigation the workspaces and dataflows are displayed as usual. As soon as we try to load them, the error appears; Expression.Error: Access to the resource is forbidden (German: Expression.Error: Der Zugriff auf die Ressource ist untersagt.)
Loading Data from semantic Modells from Workplaces for example works.
Latest Finding: I can load data when i use Power BI Desktop on a Server/VM
Thanks for all the help,
seems like a cybersecurity tool of us blocks the download. This tool does't run in admin context.
10 Replies
Hi LuITS ,
This issue sounds like a local authentication or network policy conflict. Since it works from a VM but not your local machine, here are a few things to check:
1. Credential Scope
Go to File > Options and settings > Data source settings in Power BI Desktop. Remove any saved credentials for Power BI Dataflows and try reconnecting. Make sure you're signed in with the correct account.2. Tenant Restrictions
Some organizations enforce conditional access or tenant restrictions that block access from unmanaged devices. The VM might be domain-joined or compliant, while your local machine isn’t.3. Firewall or Proxy
Check if your local machine is behind a proxy or firewall that blocks certain Power BI endpoints. You can test this by running Power BI Desktop as admin or from a different network.4. Power BI Desktop Version
Make sure you're using the latest version of Power BI Desktop. Older builds sometimes have issues with OAuth tokens or service endpoints.If the issue persists, this Microsoft doc might help:
Microsoft LearnLet me know if you want to test with a specific workspace or trace the network calls.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
Translation and formatting supported by AI
Thanks, i updated all Versions. Updated Credentials. Still running into the error. Waiting for IT to help me with Firewall.
Can this additional Error help you?Fehler beim Speichern von Änderungen auf dem Server. Zurückgegebener Fehler: "OLE DB- oder ODBC-Fehler: Eine Ausnahme vom Typ "Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException" wurde ausgelöst.. ".
Hi LuITS
Thank you for reaching out to the Microsoft Fabric Forum Community.
burakkaragoz rajendraongole1 Thanks for your inputs.Yes, this error looks like an access issue, as you and others have mentioned. It likely occurs because access is being blocked or restricted on your local machine, not in the Power BI service.
Please check with IT help for any local security policies, network restrictions. Also, review your credentials and ensure you have the necessary access permissions.
If the issue still persists, feel free to reach out to the community again for further assistance.
Thanks.
Hi LuITS -Similar thread with solved approaches:
Solved: Details: "Access to the resource is forbidden." - Microsoft Fabric Community
Power BI Dataflows Access to the resource is forbi... - Microsoft Fabric Community
Expression.Error: Access to the resource is forbid... - Microsoft Fabric Community
Hope this helps.
rajendraongole1 , burakkaragoz
Hi, it still doenst work.But i found out:
- i log in on pc with normal user, open Power BI desktop, sign in with my user-mail -> Error
- i log in on pc with admin user, open Power BI desktop, sign in with my user-mail -> it loads data
-i log in on server with admin user, open Power BI desktop, sign in with my user-mail -> it loads data
Any ideas why i need admin rights? It all worked fine without in the past months.Thanks for all the help,
seems like a cybersecurity tool of us blocks the download. This tool does't run in admin context.
