Deleting column in designer, then removing from SQL view causes error.

This was in the desktop, not the service.

When the column is removed from the report view, and then from the underlying SQL view. There is no way to refresh the meta data the report needs.

When I go into Power Query, and do a refresh there, I get an error because it seems to also execute/check any measures or logic the column might have been used in for the report. Because those references are never updated, you're just stuck.

I found I had to open the report. open Power Query, remove the column. Click Apply, and refresh. Then remove the column from the SQL view.