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

[BCWdesign]

I am trying to expand nested tables from an xml. 

Mots have worked without issue but the last few are not working as I get the below message 

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

I have tried expanding the table and then replacing the blank values but with no luck

Any ideas?

[Anonymous · Accepted solution]

Hi @BCWdesign 

Based on your error message, I think your problem should be that some of the data is not in table format. Therefore, Power Query can only expand tables and null values will return an error.

I found two posts with similar questions to yours for your reference:

The solution of this post is to copy the table, filter the first table for all tables then expand it. Filter the second table for all data that is not table data and then merge the two tables using the Append function.

Solved: OLE DB or ODBC error: [Expression.Error] We cannot... - Microsoft Fabric Community

Append queries - Power Query | Microsoft Learn

The solution of this post is to standardize the format.

Solved: Cannot convert value to type table - Microsoft Fabric Community

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.