Forum Discussion
power query error "expression error"
Hi, I'm getting a recurring expression error on this 3326 tab, where nothing had been change prior in power query. this is what it looks like within power query: when I select "go...
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
