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.
What about just changing columns quantity in M query?
I used advanced editor in Data Source:
let
Source = Csv.Document(File.Contents("C:\Users\user\Desktop\AddressType.csv"),[Delimiter="|", Columns=5, Encoding=1200, QuoteStyle=QuoteStyle.None]),
#"Change1" = Table.TransformColumnTypes(Origen,{{"Column1", Int64.Type}, {"Column2", type text}, {"Column3", type text}, {"Column4", type datetime}})
in
#"Change1"In the code (source line), instead of Columns=5, you just change to Coumns=6 and it adds the new column. It worked for me.
