'OLE DB or ODBC error: [Expression.Error] The value "" cannot be converted to the Table..'

Question

Hi all,&nbsp;I'm pulling xml data from a folder using Power Bi Desktop.&nbsp;When I have expanded all the columns, I get the following error message when trying to apply the query changes.&nbsp;The changes could not be saved to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The value "" cannot be converted to the Table..'.&nbsp;I can't figure out what kind of value "" can be.&nbsp;The folder is contained on a local network path, and contains various file extension: for expanding only the .xml files i actually filter only the ".xml" in the column extension.&nbsp;Has anyone else come across this error message?&nbsp;Thanks in advance,&nbsp;Manuel&nbsp;&nbsp;

thesott94 · Accepted Answer

Hi,&nbsp;v-yalanwu-msft&nbsp;&nbsp;I solved in another way that I post here in the hope that it will be of help to someone.&nbsp;First, I started to expand from the beginning of the query the columns and locate which column was causing the issue.&nbsp;&nbsp;Second, i removed the passage where I expand the problematic column and i added a custom column which has this function:&nbsp;Table.AddColumn(#"Problematic Column", "NameNewColumn", each if [#"ProblematicColumn"] is table then "[Table]" else if [#"ProblematicColumn"] is record then "[Record]" else if [#"ProblematicColumn"] is list then "[List]" else if [#"ProblematicColumn"] is function then "[Function]" else [#"ProblematicColumn"])&nbsp;Third, i used filter in the "NameNewColum" trying to locate if there was any other values besides [Tabel] and I actually found that there was some rows without any kind of values (note that the column quality tools always reported 100% valid values). I proceeded to filter only the table values then.&nbsp;&nbsp;Fourth, i proceeded to expand the problematic column with the filter applied and then the error does not show up anymore.&nbsp;Hopefully this will be helpful for someone in the future,&nbsp;Manuel

Forum Discussion

'OLE DB or ODBC error: [Expression.Error] The value "" cannot be converted to the Table..'

2 Replies

Related content

Snowflake connector: "We cannot convert the value null to type Text"

Expression.Error: The column " " of the table wasn't found.

[Expression.Error] We cannot convert the value "" to type List

Expression.Error: We cannot convert the value "[Record]" to type List. Details: Value=[Record]

Data source error: Expression.Error: We cannot convert the value "[Table]" to type Table.. Microsoft