cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,882)