How to change data source from local folder to sharepoint Folder

[ARP331AHS269]

I want to import all the files within the subfolders by just selecting the parent folder name 

How can I do it on Power BI similar to import data from folder option in Excel ?

[Mikelytics · Accepted solution]

Hi @ARP331AHS269 

Please replace your Source Step in Power Query with the following.

SharePoint.Files("Sharepoint Link", [ApiVersion = 15])

SharePoint Link looks something like this = https://YourDomain/sites/YourSharePointName (not folder name)

Please use authentication via Microsoft Account.

When the connection is successfull you will see all items from the sharpoint and then you have to filter to the right folder.

More information: Power Query SharePoint folder connector - Power Query | Microsoft Learn

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.