Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

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.Mashup.Engine.Interface.ResourceAccessForbiddenException" when trying to update the data connections. I realize this seems to be a common problem and the recommended solution in many forum posts is to reset the global permissions and try again.

This fix does in fact work for me and my team, but It's still a bit annoying to guide the affected users through the neccssary steps to reset their permissions every few months.

So I wanted to ask if anyone has found a permanent solution yet?

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Hi and thanks for your reply! We're using PowerQuery to connect between Excel files in SharePoint online.

v-jingzhang
Community Support
Community Support

Hi @Syndicate_Admin 

 

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.