Adding Columns

[rickarm]

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 · Accepted solution]

@rickarm

Hi,

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

 

Best Regards!

Dale

[rickarm]

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]

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

[MarcelBeug]

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.

[Anonymous]

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