Amending a Query to recognize an additional column in an Excel data source

The error points to the update: it does not appear to pick up the new column.

You don't need to add code to change the column type in order to pick it up, it should happen automatically.

I've heard of this, but I've never seen it.

People used to say "you have to add the column to the end in Excel, not the middle" or "You have to update the first step in the query - by clicking on the gear in the query and update steps" - I've never seen this either

Therefore, if I were you, I would double check that the query is pointing to the correct file (not the previous version of it)

Test an experiment by creating your own Excel file and connect to it using powerbi, then add a column to Excel and update the powerbi query. See if they pick it up.

There is also another method to convert the data into a worksheet into a table and connect powerbi to the table - you should be able to google it.

Good luck.

That worked, Thank you! 🙂