Updating a text file as a data source results in not finding a column

[Anonymous]

Hi guys,

i used a simple txt for data source and it works really except that if i add a column to the data i get an error message when trying to update.
Seems like it's mapping not to "headers" but to column "number" am i right?
Any way to update easily?

[v-chuncz-msft]

@Anonymous,

You may check code in The Advanced Editor.

[Anonymous]

Coming from Tableau i didnt expect PowerBI to be so "lazy" at updating data 🙂

[v-chuncz-msft]

@Anonymous,

It all depends on the query code.