Solved: Data Refresh Error

robofski · ‎03-23-2017

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 · ‎03-23-2017

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.

View solution in original post

robofski · ‎03-23-2017

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.