Add a new column to the existing data set and refresh

[ewuchatka]

Hello

I would like to add a new column to the existing data set in Excel and refresh my dashboard.

I have already built a dashboard based on the data set and at the moment the only way round it I can see is to build it again from scratch. However, there must be a way round it!

Please help 🙂

Thank you

Ewa

[shettysunith]

@YOURBEERGUY : I couldn't find the 'column count' at the top of advanced editor, Can you help me with a screenshot of it ?

Thanks in Advance

[Anonymous]

Top row, after the source file destination and delimiter

[Anonymous]

Thank you YourBeerGuy- this did the trick for me!

[Noel_Villan]

Yeah, thank you YourBeerGuy. It works from my end as well.

[YOURBEERGUY]

I had the same challenges adding 2 columns to the end of a worksheet. I mirrorred the verbiage in the advanced editor but still got 'column not found' errors.  After some detective work i noticed that there is a 'column count' towards the top of the advanced editor.  When i changed that from 17 to 19 (+2 columns) and added the correct verbaige {"NEW ACCOUNT NAME", type text} or whatever it was, BINGO.  MUST CHANGE THE COLUMN COUNT IN ADVANCED EDITOR

[SA_NYC]

Ah terrific, thanks for that pointer about adding it to the end of the table, I didn't know that. Very helpful.

[Seth_C_Bauer]

@ewuchatka This should just work... Add the column to the Excel file, save, click refresh in Power BI. The new column should appear.

If you modify a column, then that is a different process.