Forum Discussion
How to change data source from local folder to sharepoint Folder
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 ?
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.
1 Reply
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.