Forum Discussion
New columns in dataset and Automated Refresh
Still working through some newbie questions... I currently use the Refresh function (button) in Power BI to update my dashboards on a daily basis. The source is simply a .csv flat file in a netw...
With CSV as source, you have to edit the source query to change the number of columns. PowerBI desktop does not automatically add the additional columns.
Source = Csv.Document(File.Contents("C:\yourfolder\yourfile.csv"),[Delimiter=",", Columns=10, .....),In the above example, you have to Change the columns to 11 for the new column to reflect.
ceebu
Advocate I
Advocate IWith CSV as source, you have to edit the source query to change the number of columns. PowerBI desktop does not automatically add the additional columns.
Source = Csv.Document(File.Contents("C:\yourfolder\yourfile.csv"),[Delimiter=",", Columns=10, .....),In the above example, you have to Change the columns to 11 for the new column to reflect.
This post is old but not accurate. If [Columns] is not specified, Csv.Document will read whatever number of columns it finds in the input.
https://learn.microsoft.com/en-us/powerquery-m/csv-document