Update errors for tsv files

Hey data_insights 

See this thread: https://community.powerbi.com/t5/Desktop/Columns-removed-from-excel-file-and-report-not-loading/td-p/458989

Open up the "Edit Queries" in the PBIX file

Select the Query for the file in question

In the "APPLIED STEPS" to the right find the step where the columns are loaded and redop that step.

Alternatively, requery the datasource.

Hi, data_insights 

Here is my data in a Excel file for test. Then I used Power BI to connect the Excel file.

Then I deleted the column 'thing'. When I click 'Refresh' in the Power BI Desktop, I got the same error with you.

To solve the problem, you may click 'Edit Query', go to Query Editor, remove the selected 'thing' column definition, click 'Close and Apply'.

Finally, you will be successful to refresh the file.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.