Forum Discussion
Authentication Problems with SharePoint Folders
Hi sommerp ,
One possible reason why you are getting the authentication error is that you are using the Web connector instead of the SharePoint Folder connector. The Web connector is designed to connect to a single file or web page, not a folder. The SharePoint Folder connector is the one that can combine multiple files from a SharePoint folder into one query. To use the SharePoint Folder connector, you need to enter the root URL of the SharePoint site, not the folder path. For example, if your folder path is https://COMPANYNAME.sharepoint.com/teams/Team-YYYYYY/Shared%20Documents/ZZZZZZ/FOLDER, then you need to enter https://COMPANYNAME.sharepoint.com/teams/Team-YYYYYY as the site URL.
Another possible reason why you are getting the authentication error is that you are using the wrong credentials or privacy level for the SharePoint site. You need to use the same credentials and privacy level that you use to access the SharePoint site from your browser. You can check and edit your data source settings in Power BI Desktop by going to File > Options and settings > Data source settings.
Power Query SharePoint folder connector - Power Query | Microsoft Learn
Quick steps for connecting to SharePoint using Pow... - Microsoft Fabric Community
Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn
Why can't I connect SharePoint and Power BI? (windowsreport.com)
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi!
Thanks for the tips!When connecting with the SharePoint connector and Site URL it works, but is there a possibility to further drill down to only a single folder?
In my File structure there is the possibility for more than one folder from a Teams/Sharepoint page that I want to connect as two seperate data connections. Also, there are *.xlsx files in the same filepath as the folder(s).
When I connect via the sharepoint connector, I only get all possible files that are stored in the Sharepoint structure as one connection and the connection assumes (I suppose) the first found datasource as the data structure.
There is the possibility to go to the combine and transform data step and then filter for folder path in the first transformation step. But this doesn't work if there is an unknown file typ to PowerBI in one of the folders as it then doesn't let me proceed to the transformation steps.Also I would then have to change following steps depending on which data structure PowerBI assumed in the first place.
Is there a more elegant solution that could be more "end-user" friendly?
Again, thanks for the help, this brought me at least one step closer to a solution!
