Forum Discussion

Arkhos94's avatar
Arkhos94
Helper IV
5 years ago
Solved

Sharepoint folder source / How to filter well ?

After a lot of try I manage to connect my power query to my sharepoint folder. The data I want to load is a set of excel file (one per month, named "nationales + year-month" (so "Nationale 2021-05", ...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    = Table.SelectRows(Source, each Text.StartsWith([Name], "Nationale"))
Arkhos94's avatar
Arkhos94
Helper IV
5 years ago

Thank you CNENFRNL 

 

I think it's time for me to start learning the coding language used by power query

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Yes, indeed, perhaps 20% of ETL tasks can be completed by UI; the real power of Power Query lies in the M language.

Good luck!