Forum Discussion
Get Data "From Folder" from Sharepoint Folder
Hi CraigSchulz
After researching, i haven't found any way to connect directly to Sharepoint Folder as you described.
A well-known way is using "Sharepoint Folder" connector and selecting your desired folder from the displaying list of folders' path.
Combining Excel Files hosted on a SharePoint folder with Power BI
After we connect to sharepoint successfully, we’ll be able to see all of the files from all of the folders that we have access to in that specific site.
This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
Best Regards
Maggie
Hi CraigSchulz,
The format for connecting to SharePoint folders is https://xxx.sharepoint.com/sites/xxx.
I did this just now in a blank PBIX. Is not what you're looking for, or not what you're seeing?
Thanks for the quick response. I had just used https://xxx.sharepoint.com/. Did not put in the "/sites/". And what does the final "xxx" stand arepresent?
When I do as described above I get a list of files similar to what you indicate in your response - a list of many different files and file types. The thing is, my purpose in connecting to a folder is to have a PBI query pull all the files in the folder into one table in PBI, as discussed by Rob Collie and Avichal Singh in their book Power Pivot and Power BI, 2nd Edition. It seems, therefore, that I need to have a folder populated with files all of the same type and construction, readable by PBI, xlsx of csv files for insance. Then it appears I need to have PBI point to that folder, not the root sharepoint directory.
Does the "xxx" at the end of your format represent the folder name? Sorry if I am being dense. The book does say it can be done using a Sharepoint folder IF YOU HAVE IT MAPPED AS A DRIVE. But that seems to defeat the purpose of having a PBI project that is portable and my client can continue to use if I am no longer in the picture with them.
- Craig
The link should be https://[tenant].sharepoint.com/sites/[SharePoint group name].
Once you're connected, it should list all files available in that group, regardless of location. Then you can use the "Combine and Edit" button to go from there. You don't need to do any filtering by filetype - everything is handled by the combination process.
This isn't mapped, I'm just connecting directly; as long as the client has access to the SharePoint, everything should function just fine.
Well, it should list all the files but the problem is that it dosen't. I went through the entire uploaded list but there are several files missing, including those which I need in my report :(
