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 also have the same problem as the topic starter.
Both the proposed solutions work for me, changing the column amount in the advanced editor and switching the source to automatic.
But is there a possibility to make the number of the amount of columns in the advanced editor a variable?
So before the data is imported, the columns are counted in the source, stored as a variable and then with the import source step the variable is put after the columns
Ex. [Delimiter=";", Columns=X, Encoding=1252, Quotestyle=Quotestyle.None]),
Where X is the counted variable.
Maybe this could automate the 2 solutions, if it is possible