Data Refresh Error

[robofski]

I was trying to clean up a SQL view that I use as a data source for one of my Power BI reports and remove a few columns that I wasn't using.  Unfortunately I removed a column that was being used so my load failed.  I put the column back in the view and now on refresh I'm getting the following error:

Any one have any ideas how I can past this?

[robofski · Accepted solution]

Managed to fix this so posting the solution in case anyone else comes across the issue.

I created a new query to the same SQL view in the same pbix file and imported 1 column.  This created a new table and cleared out all the data from the existing table.  I then deleted the new table I'd imported and did another refresh and the existing table loaded just fine.