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.

zebing2's avatar
zebing2
Icon for Advocate II rankAdvocate II
8 years ago

Are you kidding me? I add columns ALL the time. I have to write some sort of code formula every time I refresh my data!!!

 

This is kind of a deal breaker, Microsoft. This switch from Tableau isn't being smooth sailing.