Forum Discussion
Helper IIFiltered Hidden Files
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 !
5 Replies
- HarishKM
Super User
bboy0009
You can refer this document Table.SelectRows - PowerQuery M | Microsoft LearnThanks
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
YoungLearningHelper III
Doesn't really say much though, could you kindly shed some light?
- Greg_Deckler
Community Champion
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.
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?
