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

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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