Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • ceebu's avatar
    ceebu
    9 years ago

    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's avatar
ceebu
Icon for Advocate I rankAdvocate I
9 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

ceebu

 

Thanks.  Worked perfectly.