Forum Discussion
Impactful IndividualHow to read the files from a Sharepoint folder?
Hello,
I'm trying to create a dataflow in Power BI Service to connect to a sharepoint folder.
When typing the root name of the site I get a blank editor:
But when trying to type the URL with the folder name, adding to the above: "/Documents/FolderABC/"
I get an error.
Can anyone explain me how to read all the files from a Sharepoint folder?
It works well with Power BI Desktop reading a local folder on my disk, but I can't make it on a data flow.
Thanks!
6 Replies
- GilbertQ
Super User
Hi there
You should only have to put in the root folder URL when connecting to SharePoint.
You could also do it in Power BI Desktop and then copy the M query directly into your dataflow?
And finally here is a blog post on how to connect to the SharePoint files: https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/ 
v-lionel-msftCommunity Support
Hi webportal ,
The problem should be on the sharepoint link.
Make sure you supply the root address of the SharePoint site.
Please refer to the video in this document that how to get the sharepoint link.
https://docs.microsoft.com/en-us/power-bi/desktop-sharepoint-online-list
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
