Forum Discussion
power query error "expression error"
Hi adlbrk
Realistically speaking I don't think someone can determine the source of the issue with pictures only
PQ usually makes no mistakes when it says The column 'xyz' of the table wasn't found ==> It's highly probable that [2024-01-02] is referenced in a step where that column doesn't exist
Could you post, at least, the complete 'city 3326' query code?
or better share your workbook as I'm under the impression that query depends on other(s)
HiLorenzo
Here's the formula that appears to be in error:
= Table.TransformColumnTypes(#"Promoted Headers",{{"2024-01-02", type date}})
Hi adlbrk
The step that raises the error doesn't help I'm afraid (I wrote Could you post, at least, the complete 'city 3326' query code?)
When you're in the Power Query Editor, click (in APPLIED STEPS) on the step Promoted Headers (highlighted in blue below):
and check the table Headers (column names) - Sure none of them is named 2024-01-02
promote headers formula is this:
= Table.PromoteHeaders(#"Renamed Columns", [PromoteAllScalars=true])Don't get me wrong but it's difficult to believe...
- In my 1st reply I asked you to post, at least, your complete query code
=> Still not received it - In my 2d reply I wrote "When you're in the Power Query Editor, click (in APPLIED STEPS) on the step Promoted Headers...and check the table Headers (column names) - Sure none of them is named 2024-01-02
=> You post a pic. showing the Promoted Headers step but do not tell me if any of the column (at that step) is named 2024-01-02
If you want to sort this issue out - with help from forum(s) - please provide the information you're asked
That said, a couple of things are obvious to me:
- Looking at the query step names, that query has been modified. No problem in principle as long as we understand how a query works and we know what we do
- Looking at your last picture it's interesting to note that the 1st few rows of the table (at the Promoted Headers step) show 2024-01-02 in the [Date] column
- There's a Renamed Columns step prior to the Promoted Headers step. I wonder what column(s) are renamed at that step???
- In my 1st reply I asked you to post, at least, your complete query code