cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
irnm8dn
Post Prodigy
Post Prodigy

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 network folder that is replaced daily.

 

I have updated the dataset to include an additional column, which upon Refresh is not represented in Power BI (but it is clearly there in the .csv / flat file).  Two questions:

 

1.  When expanding a source dataset to include more columns, how do I get Power BI to acknowledge and accept the change and include the expanded information...or do I need to rebuild from scratch?

 

2.  Since I move the flat file to a network folder, in Power BI how can I ping the network folder at a scheduled interval to look for and refresh the data?

 

Thanks.

1 ACCEPTED SOLUTION

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.

View solution in original post

5 REPLIES 5
zebing2
Advocate I
Advocate I

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.

Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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

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

 

Thanks.  Worked perfectly.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors