power pivot / power query: showing (blank), but CSV file does not show blanks.

[countryfan_nt]

Hello friends, hope all is well!

I have a powerquery that cloads CSV files, I take the power query make a power pivot. trouble is I keep getting (blank) in pivot table slicer.

I opened the csv and couldn't find any blanks, I deleted all the rows underneath the set of data, I deleted all the columns after the set of data.
what do I need to do to clear out the (blank)?

Thank you very much in advance!

 

[sandy666]

do you know what a blank in .csv looks like ?

if there is no any confidential information could you post a sample of .csv?

 

[countryfan_nt]

 

[sandy666]

I can only say I see null there where data should be
but why it's happen I need csv

 

[sandy666]

maybe try: = Table.SelectRows(#"Changed Type1", each ([InvoiceType] <> null)) or = Table.SelectRows(#"Changed Type1", each ([InvoiceType] <> ""))
instead of this