new columns added to sql source data column heading not refreshed

[Rach]

I have added 3 new column to  my source table in sql. When I refresh I get the old table scheme remaining but with the new column data put under the old column headings and with the last 3 columns missing. So new data in old schema.

I have refreshed both in and out of the Query editor. I've clicked on Chose Columns and can only see my old column headings shown not the new. I have tried to delete the table completely from the query editor and the desktop but still remembers the old table.

Any help appreciated.

[Rach · Accepted solution]

RESOLVED - The problem was I was adding the new columns in the middle of the table rather than at the end. The new columns refresh fine in Power BI desktop once I moved them to the end of the SQL view.