When you get an empty CSV file that probably means that none of the datastores conform to the conditions in the Where-clause.
Judging from your description, when you leave out the Where-clause, it sounds as if you dropped the pipeline symbol ('|') at the end of the line.
The FreeSpaceGB property is a decimal, so you can't compare it to a string as "8190*" like you propose.
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference