we cannot convert the value null to type logical

Hi,

Hopefully someone can point me in the right direction with this.

I'm trying to import a data csv file from Azure Data Lake into Power BI but get the following error message. I've tried this with the full data set and a test set of 10 rows and get the same result. When i try the full dataset from excel it comes into Power Bi but ignores some rows due to errors, the test set comes into Power BI without any issues.

I don't want any of the columns to be logical/Boolean, just want to see the data, can someone provide some background on how to overcome this or let me know if I'm doing somthing wrong.

Data is made up of a combination of text, numbers and dates.

Thanks

Eamonn