Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |