OLE DB or ODBC error: [Expression.Error] The column 'Column1' of the table wasn't found..

Like (0) Share

Report

Posted on 14 May 2019 16:57:03 by geraldoaax

I have a problemn after one a invoke function and expand a table..

Appear this message:

OLE DB or ODBC error: [Expression.Error] The column 'Column1' of the table wasn't found..

My script is:

#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"patioID", "patioDescricao", "pilhaID", "pilhaDescricao", "dataInicioRanges", "dataFimRanges", "rangeInicio", "rangeFim", "toneladasPrevista", "toneladasRealizadas", "fogo", "ap", "litio", "tipoMaterialID", "tipoMaterialDescricao", "materialID", "materialDescricao", "frenteLocalOrigemID", "frenteLocalOrigemDescricao", "frenteLocalDestinoID", "frenteLocalDestinoDescricao"}, {"patioID", "patioDescricao", "pilhaID", "pilhaDescricao", "dataInicioRanges", "dataFimRanges", "rangeInicio", "rangeFim", "toneladasPrevista", "toneladasRealizadas", "fogo", "ap", "litio", "tipoMaterialID", "tipoMaterialDescricao", "materialID", "materialDescricao", "frenteLocalOrigemID", "frenteLocalOrigemDescricao", "frenteLocalDestinoID", "frenteLocalDestinoDescricao"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"frenteLocalOrigemID", type text}}),
#"Invoked Custom Function" = Table.AddColumn(#"Changed Type", "GetDetailsTeores", each GetDetailsTeores([frenteLocalOrigemID])),
#"Expanded GetDetailsTeores" = Table.ExpandTableColumn(#"Invoked Custom Function", "GetDetailsTeores", {"frenteLocalID", "teorDescricao", "teorValor", "idTeor"}, {"frenteLocalID", "teorDescricao", "teorValor", "idTeor"})
in
#"Expanded GetDetailsTeores"

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

v-xida-msft on 15 May 2019 at 07:13:15

Like (0)

Report

Re: OLE DB or ODBC error: [Expression.Error] The column 'Column1' of the table wasn't found..

Hi @geraldoaax ,

Does this error occur when you execute it within your Power Query Editor within your Power BI?

The user @rakeshkumar has faced similar issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/The-column-N-of-the-table-was-not-found/m-p/278834

Based on the error message that you mentioned, I think you may have some modeling happening in the query editor that is erring on that column name. Go into Query Editor and back track through applied steps until you find where the error is. Sounds like some small typo (i.e. initial column was 'Column', new column is 'column1','Column1 ', ' Column1', etc

Please check and see if the response within the following article would help in your scenario:

https://www.reddit.com/r/PowerBI/comments/85ve8r/expressionerror_for_column_in_table_no_changes/

Best regards,

Was this reply helpful? Yes No
timl 35,706 Super User 2025 Season 2 on 14 May 2019 at 19:49:40

Like (0)

Report

Re: OLE DB or ODBC error: [Expression.Error] The column 'Column1' of the table wasn't found..

Hi @geraldoaax

I think we would need to see your data to diagnose this - the likely cause is that Table.FromList doesn't produce a "Column1" result, which the the call to ExpandRecordColumn expects.

Since this is PowerQuery/PowerBI question, you might have better success in finding your answer through the PowerBI forum. Perhaps @Anonymous can help move this post?

Was this reply helpful? Yes No