Forum Discussion
Update errors for tsv files
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 !
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.
2 Replies
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.