topic Re: Access in SharePoint folder in Power Query takes a lot of time in DAX Commands and Tips

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

Anonymous — Mon, 22 Jun 2020 08:36:07 GMT

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

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

Anonymous — Mon, 22 Jun 2020 09:00:14 GMT

Hi Anonymous ,

Have a look at this video

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)

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

Anonymous — Mon, 22 Jun 2020 09:14:22 GMT

Hi Anonymous

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.