Update errors for tsv files

[data_insights]

How can I update PBI file without having to build a whole new report every time I update the source.

I'm importing a bunch of tsv files into power bi. When I refresh the query to update tsv and if the files  doesnt have a field which was previously there, the file doesn't load. 

Eg: My file has 4 columns, 1.name 2.place 3. animal 4. thing

I updated the tsv file in the source location to have only 3 columns now - 1. name 2. place 3. animal

When I refresh PBI after this update, the file doesn't load in power bi and gives me the message: "The column was not found"

Thanks !

[Anonymous · Accepted solution]

Hey @data_insights 

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

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.

[v-alq-msft · Accepted solution]

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.

[Anonymous · Accepted solution]

Hey @data_insights 

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

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.