The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 !
@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 !!
Doesn't really say much though, could you kindly shed some light?
@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?
@qinh_ann yes, if you have or not hidden files Power Query automatically apply step 🙂