Re:Power Query gave me results I could filter to get this.
Do you want to get list of full path and size of each files?

didn't allow me to filter as I ultimately wanted to

What kind of filter?
Can you share some data and expected result?