we cannot convert the value null to type logical

[eamonnde]

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

[v-cherch-msft]

Hi @eamonnde

You may refer to below posts to check if these are helpful to you. If it is not your case, you may submit a support ticket.

https://community.powerbi.com/t5/Service/We-cannot-convert-the-value-null-to-type-Logical-in-Service...

https://community.powerbi.com/t5/Integrations-with-Files-and/Cannot-get-data-from-Data-Lake-due-to-e...

Regards,

Cherie