cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chademe Frequent Visitor
Frequent Visitor

OLE DB or ODBC error: [Expression.Error] We cannot convert the value null to type Logical.

Hi,

 

I'm receiving this error with my query, and I can't understand why.  I've checked some other topics for this issue, but haven't found a solution.  In order to isolate the problem, I went from the end of my query and deleted every step until I found where the error was occuring, and it seems to be happening when I merge two queries together.  This is where the problem happens:

 

#"Merged Queries2" = Table.NestedJoin(#"Added Conditional Column3", {"lookup for case name"}, #"raw data", {"Contract ID"}, "raw data", JoinKind.LeftOuter),
    #"Expanded raw data" = Table.ExpandTableColumn(#"Merged Queries2", "raw data", {"CBT", "CT", "Case"}, {"raw data.CBT", "raw data.CT", "raw data.Case"})

 

If I delete the Table.ExpandTableColumn step, the error goes away.  I've checked the columns in my raw data file, and there are no nulls there.  I can't figure out what null it's trying to convert.  Any help?

 

thanks,

1 REPLY 1
Community Support Team
Community Support Team

Re: OLE DB or ODBC error: [Expression.Error] We cannot convert the value null to type Logical.

Hi @chademe ,

This happens if you have mixed data types in your column to expand, please check the #"Changed Type" step in previous.

Best Regards,

Teige

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors