Forum Discussion

Rach's avatar
Rach
New Member
9 years ago
Solved

new columns added to sql source data column heading not refreshed

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.

  • 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.

1 Reply

  • Rach's avatar
    Rach
    New Member

    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.