Forum Discussion
Add an extra field from a data source
A power bi newbie here. Say if I import a table A from a data source into power bi, some minor changes to the imported dataset. calculated columns, measures etc. Now I add a new field in the table...
- Anonymous
If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
I know this was solved but found an even simpler solution.
In power query select the query in question > right click > select advanced editor
On line 1, where it lists your file source, change column = x to column = x + y
where x = the default column number listed
where y = the number of additional columns missing (OP situation would change it from 4 to 5 if the original file had 4 columns and 1 added column so should list as column = 4 to column = 5)