Forum Discussion
OLE DB or ODBC error: [Expression.Error] We cannot convert the value "" to type Table..
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?
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.