power query error "expression error"

Question

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 to error" it sends me back to this step:

Please advise thanks

lorenzo · Answer

Hi&nbsp;adlbrk&nbsp;&nbsp;Realistically speaking I don't think someone can determine the source of the issue with pictures onlyPQ usually makes no mistakes when it says The column 'xyz' of the table wasn't found ==&gt;&nbsp;It's highly probable that [2024-01-02] is referenced in a step where that column doesn't exist&nbsp;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)

adlbrk · Answer

HiLorenzo&nbsp;Here's the formula that appears to be in error:= Table.TransformColumnTypes(#"Promoted Headers",{{"2024-01-02", type date}})&nbsp;

lorenzo · Answer

Hi&nbsp;adlbrk&nbsp;&nbsp;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?)&nbsp;When you're in the Power Query Editor, click (in APPLIED STEPS) on the step&nbsp;Promoted Headers (highlighted in blue below):&nbsp;and check the table Headers (column names) - Sure none of them is named 2024-01-02

adlbrk · Answer

Lorenzo&nbsp;promote headers formula is this:= Table.PromoteHeaders(#"Renamed Columns", [PromoteAllScalars=true])&nbsp;&nbsp;

lorenzo · Answer

adlbrk&nbsp;&nbsp;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=&gt; Still not received itIn 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=&gt; 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-02If you want to sort this issue out - with help from forum(s) - please provide the information you're asked&nbsp;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 doLooking 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] columnThere's a Renamed Columns step prior to the Promoted Headers step. I wonder what column(s) are renamed at that step???

Forum Discussion

power query error "expression error"

Share

Resources