Table refresh after deleted column

[easyleesie]

Hi Guys

This seems like a stupid question but I don't know the definitive solution...

I loaded a massive dataset and then deleted a column. Now when I refresh it can't find the deleted comlumn and gives an error :

"Load was cancelled by an error in a previous table".

I have tried to change things in the transform data area, but I can't fix it. Please help.

Thanks

[v-eachen-msft]

Hi @easyleesie ,

Do you mean to remove a column in datasource or in Power BI?

If it is the former, you could follow the reply of amit.

If the latter one, you could go to query editor to delete "Removed Columns" step.

[amitchandak · Accepted solution]

@easyleesie , Go to Data Transformation.

On table right click and open advance editor. There you will see all column name. Remove the column name/ype  there and save.

Keep a back of the script there.

[Anonymous]

This is:

1) ridiculous >:-(((

2) working 😄