Forum Discussion

M0skus's avatar
M0skus
Frequent Visitor
4 years ago
Solved

Get Excel data from several sharepoint folders

Hi!    I havent had any luck figuring this out on my own, and I'm pretty new to PBI.  Would appreciate a nudge in the right direction.   Our organization have 30 branches, each with their own Te...
Need Help
  • M0skus's avatar
    M0skus
    4 years ago

    So I finally managed to get all the data from the different folders in Sharepoint. 

     

    What ended up being the solution was setting up individual queries for each of the sharepoint folders, then appending them all as one new query. 

     

    From there I used jennratten's tip on text filters, and was left with only the files I wanted. 

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi M0skus 

 

Are these files on the same SharePoint site? If they are, you can use SharePoint Folder connector. This connector will get all files on a site. Then you can filter by Name or Folder path to keep only files you want. Combine them into one query. See https://powerbi.microsoft.com/blog/combining-excel-files-hosted-on-a-sharepoint-folder/ 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

M0skus's avatar
M0skus
Frequent Visitor
4 years ago

Hi! 

 

Thanks for replying. 

I tried you suggestion again, but I cant seem to find the files that I know are located on our company sharepoint. As soon as I try adding a text filter, no results are shown. 

 

Edit:

I tried adding a /sites to the sharepoint URL, as all branches have their own area on sharepoint - (/sites/Branchname) This would narrow the search down greatly, as it skips all contents of the root path. 

That didnt work, produces the following error: