Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I removed a column in the Table View from a table called 'Headlines' which I no longer need. I also removed the corresponding column from the source spreadsheet in Excel. Now I get an error when I refresh the data saying that the missing column wasn't found. How can I solve this?
Solved! Go to Solution.
you deleted it in the Table view, however, it is still in the Power query.
you need to go to transform data
you may find there is an error.
you can delete the corresponding part in the M language
or delete the change type step and change type again.
Proud to be a Super User!
you deleted it in the Table view, however, it is still in the Power query.
you need to go to transform data
you may find there is an error.
you can delete the corresponding part in the M language
or delete the change type step and change type again.
Proud to be a Super User!
Thanks - that solved it!
you are welcome
Proud to be a Super User!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 20 | |
| 14 | |
| 13 | |
| 13 |
| User | Count |
|---|---|
| 62 | |
| 40 | |
| 39 | |
| 39 | |
| 38 |