I have a question regarding refreshing my dataset.
My first dataset contained a fixed amount of colums for which I edited a couple of queries. In my refreshed/new dataset a column was added. When I refreshed the dataset, I got the error message which is mentioned in the title.
It seems that the most right column does not appear in the new dataset causing the column not to be found. It looks like Power BI sets a fixed amount of columns according to the original datasets and if columns gets added in the refreshed dataset, it just forgets to import the most right column. Something like this:
Original dataset:
ColumnHeader1 ColumnHeader2 ColumnHeader3 ColumnHeader4 ColumnHeader5
New Dataset:
ColumnHeader1 ColumnHeader2 NewlyAddedHeader ColumnHeader3 ColumnHeader4
Which results in ColumnHeader5 to be erased en consequently not refreshed right.
My question is: how can I fix this without having to delete all my query edits?
