Home

Access forbidden when connecting to SharePoint folder from PBI desktop

%3CLINGO-SUB%20id%3D%22lingo-sub-781485%22%20slang%3D%22en-US%22%3EAccess%20forbidden%20when%20connecting%20to%20SharePoint%20folder%20from%20PBI%20desktop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781485%22%20slang%3D%22en-US%22%3E%3CP%3ESharePoint%202016%20on-prem%2FPower%20BI%20Report%20Server%20(on-prem)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Power%20BI%20desktop%20client%2C%20when%20you%20try%20to%20'Get%20Data'%20and%20select%20the%20option%20for%20SharePoint%20folder%2C%20we%20enter%20the%20URL%20and%20trim%20the%20path%20down%20to%20the%20top-level%2C%20use%20Windows%20(AD)%20credentials%20to%20access%20the%20SharePoint%20content%2C%20it%20returns%20an%20error%20'Access%20to%20the%20resource%20is%20forbidden'.%26nbsp%3B%20We've%20tried%20using%20a%20service%20account%20specifically%20set%20up%20for%20this%20role%2C%20and%20we've%20tried%20using%20our%20elevated%20accounts%20that%20not%20only%20have%20access%2C%20but%20are%20site%20collection%20admins%2C%20and%20get%20the%20same%20results.%26nbsp%3B%20I've%20checked%20the%20logs%20and%20don't%20see%20any%20errors%20on%20the%20App%20or%20Web%20servers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-781485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-837456%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20forbidden%20when%20connecting%20to%20SharePoint%20folder%20from%20PBI%20desktop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F195198%22%20target%3D%22_blank%22%3E%40Greg%20Webb%3C%2FA%3E%26nbsp%3Bare%20you%20trying%20to%20get%20a%20file%20or%20list%3F%20I%20was%20having%20the%20same%20issue%20until%20I%20specifically%20selected%20%22sharepoint%20list%22%20instead%20of%20%22sharepoint%20folder%22%20when%20trying%20to%20connect%20to%20my%20sharepoint%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-846585%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20forbidden%20when%20connecting%20to%20SharePoint%20folder%20from%20PBI%20desktop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403523%22%20target%3D%22_blank%22%3E%40JerimeJ%3C%2FA%3EFiles%20that%20end-users%20would%20upload.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Greg Webb
New Contributor

SharePoint 2016 on-prem/Power BI Report Server (on-prem)

 

In the Power BI desktop client, when you try to 'Get Data' and select the option for SharePoint folder, we enter the URL and trim the path down to the top-level, use Windows (AD) credentials to access the SharePoint content, it returns an error 'Access to the resource is forbidden'.  We've tried using a service account specifically set up for this role, and we've tried using our elevated accounts that not only have access, but are site collection admins, and get the same results.  I've checked the logs and don't see any errors on the App or Web servers.

2 Replies

@Greg Webb are you trying to get a file or list? I was having the same issue until I specifically selected "sharepoint list" instead of "sharepoint folder" when trying to connect to my sharepoint list.

@JerimeJFiles that end-users would upload.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies