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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I would open your original Power BI Desktop file, hit refresh there and then see if your columns show up. If they do, then you should be able to republish. As for your second question, I am not aware of any way that you can do that today. Would be a nifty thing to leverage Flow for but I do not believe Flow can kick off a refresh in Power BI just yet.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Greg_Deckler

     

    This is the issue.  When I open the file, and refresh, the new column doesn't show up...

     

    Thanks for any additional input.

    • 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.