Forum Discussion
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...
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.
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.