Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I am new to power bi. I need help extracting multiple files from sharepoint folder. Here is my folder structure in sharepoint
I want to extract all the xlsx files then do the transformation.
Here is what I have done till now:
let
Source = SharePoint.Files("https://mywebsite-my.sharepoint.com/mycompany.com/", [ApiVersion = 15])
But this doesn't pull all the xlsx files from inside sub-folders.
Not sure if this "Table.SelectRows" function is the right one. Any help please?
Thank you!
Solved! Go to Solution.
Hi @ramviv,
You could change the code to the below to ensure files in sub-folders are included.
Depending on the site size, performance may not be great.
#'Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Folder Path], "https://mywebsite-my.sharepoint.com/mycompany.com/Documents/Yearly-Dataset/")),
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @ramviv,
You could change the code to the below to ensure files in sub-folders are included.
Depending on the site size, performance may not be great.
#'Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Folder Path], "https://mywebsite-my.sharepoint.com/mycompany.com/Documents/Yearly-Dataset/")),
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |