Filtered Hidden Files

[bboy0009]

Hi guys,

I didn't find an explanation for this instruction. Can you help me to understand this ? 

#"Filtered Hidden Files1" = Table.SelectRows(#"Step 1", each [Attributes]?[Hidden]? <> true)

Nothing changed when I deleted this instruction

thank you guys !

[HarishKM]

@bboy0009 
You can refer this document Table.SelectRows - PowerQuery M | Microsoft Learn

Thanks 

Harish M

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[YoungLearning]

Doesn't really say much though, could you kindly shed some light?

[Greg_Deckler]

@bboy0009 Do you have hidden files? Also, it may appear that nothing changes when previewing the data but when you actually do a refresh the hidden files will be included in the dataset versus not.

[qinh_ann]

Hi @Greg_Deckler,

I have a follow up question. Does this step get populated by Power Query automatically when there are hidden files in the folder we're pulling data from?

[Anonymous]

@qinh_ann yes, if you have or not hidden files Power Query automatically apply step 🙂