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
Highlighted
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
Highlighted

@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.

Highlighted

@JerimeJFiles that end-users would upload.