Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

cannot convert the value null to type Logical

Submitted by Anonymous on ‎06-08-2022 02:23 PM

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?

Zegote_0-1654723280654.png

 

Status: Investigating

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

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yingjl
Community Support
Community Support
‎06-08-2022 07:00 PM
Status changed to: Investigating

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
Not applicable
‎06-14-2022 01:11 PM

@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?

Idea Statuses