Forum Discussion
New columns in dataset and Automated Refresh
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.
This is the issue. When I open the file, and refresh, the new column doesn't show up...
Thanks for any additional input.
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
