Solved: Re: Adding Columns

rickarm · ‎06-08-2017

How can I get Power BI Desktop to show a new column that I've added to the underlying Excel spreadsheet?

Thanks

Rick

v-jiascu-msft · ‎06-12-2017

@rickarm

Hi,

According to my test, we can get the new column by clicking “Refresh”. Remember to save the spreadsheet first.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-jiascu-msft · ‎06-12-2017

@rickarm

Hi,

According to my test, we can get the new column by clicking “Refresh”. Remember to save the spreadsheet first.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rickarm · ‎06-15-2017

Thanks Dale,

The problem seems to be that I didn't understand that Power BI doesn't pull in a new column into the field list if all the cells are blank.

All good now. Thanks again.

Cheers

Rick

Anonymous · ‎06-08-2017

Have you instructed Power BI to do a 'Refresh'?

MarcelBeug · ‎06-08-2017

When importing an Excel sheet into Power BI, the underlying queries typically include hardcoded references to the columns.

So if you have new columns, you may need to adjust your queries accordingly.

Alternatively you can consider adapting your queries to avoid hardcoded column names, but that may be somewhat more challenging.

Specializing in Power Query Formula Language (M)

Anonymous · ‎11-20-2018

Hi @MarcelBeug

I am having the same problem. I added a new column to my underlying Excel spreadsheet & its not showing up in the Power Bi Query editor. How do I change my queries? so it can show the new column?

Thanks,

panda2018