Forum Discussion
Table refresh after deleted column
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
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.
3 Replies
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.
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.
