I have a problemn after one a invoke function and expand a table..
Appear this message:
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:
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,
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?
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2