Forum Discussion
PowerQuery access forbidden exception - Is there a permanent solution?
In my organsiation we use a lot of PowerQuery connections to Excel files on a SharePoint-Server (Accessed with organisational login). Some of my teammembers have repeatedly experienced the "Microsoft...
Where do you use Power Query when you have this issue? In Power BI Desktop, Excel, Power BI Dataflow or somewhere else?
You are connecting to onprem sharepoint server or sharepoint online? Note that if you connect to onprem sharepoint server, please use Windows or Anonymous authentication to connect. If Windows account does not work, you need to change your sharepoint server to allow windows authentication.
Kindly let me know if this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.