Expression Error on Close and Apply: We cannot create null value to type logical

[Anonymous]

Hi, 

I'm getting an error on close and apply 

I've traced a log but I can't tell from that what the issue might be.

Can anyone point me in the right direction as to what the issue might be?  

Many thanks

[v-haibl-msft]

@Anonymous

How did you get data, DirectQuery or Import mode? What modifications have you done to columns with which type?

Best Regards,

Herbert

[Anonymous]

I was trying to add a new column in Power Query and my expression was creating Null values.  I ditched that column and it loaded just fine.  

[ankitpatira · Accepted solution]

@Anonymous Basically that error means that via query editor you've done some transformations, applied some steps that cannot be successful due to some values being null in your dataset. I would suggest import data as it is rather than doing any transformations.