Access in SharePoint folder in Power Query takes a lot of time

[Anonymous]

Hello eveyone!

So I am trying to access some excel data files in a SharePoint folder and I tried to use a trick I saw somewhere where I can filter out the files that I want using a list. But doing that seems to take A LOT of time to process. Do you guys have any idea on what's going on? The code used is shown below. And I am sure that the line I mention is the problem, because when I replaced it with a fixed filter, the loading time disappeared. Thank you!

let
    Source = SharePoint.Files("sharepoint folder", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Folder Path], "KPI_Extracts")),
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each List.Contains(Files, [Name])), <- this line causes the issue
.
.
.

[harshnathani]

Hi @Anonymous ,

Have a look at this video

https://www.youtube.com/watch?v=XuLnSYjmsJo

https://www.youtube.com/watch?v=XuLnSYjmsJo

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani 

Maybe I wasn't clear enough so I do apologize for that. I don't want to connect to a SharePoint list. I already have a list and I am trying to use that as a filter to filter out the rows that I need like a text filter. Please read the Power Query code that I have included. The third line is what's giving me trouble.