cannot convert the value null to type Logical

[Anonymous]

We have been having a problem with our Power BI report not being able to refresh. We use insightly CRM and pull from there to feed our Power BI reports. We keep getting the same error (see below) and we have searched high and low in both Insightly and in Power BI. Has anyone had this same problem? If so, what could possibly be the issue?

[v-yingjl]

Based on the error message, please check that whether there are null values in the corresponding columns from the datas source which could not be converted to Logical type in Power BI Service.

You can also refer: Power BI Error : “The exception was raised by IDataReader interface.” 

Best Regards,
Community Support Team _ Yingjie Li

[Anonymous]

@v-yingjl  I am not sure what data source is causing this message. We convert a lot of data from Insightly into Power BI. How do I find the source? Or do I have to look through absolutely everything we pull from Insightly?