How to update data in PowerBI after adding columns in the original Excel file

[natahoughton]

Hello Power Bi Community,

I'm new to Power Bi, but was able to develop a report in PowerBi Desktop using data from Excel File saved in OneDrive. However, after completing the report, I realized that I needed to add two extra columns in my Excel file. I'm now trying to update my data in PowerBI after adding the columns in the original Excel file, but I can't see the columns. I tried changing the data soource from data query, but nothing.    Any tips on how to do that?

Thanks!

[v-frfei-msft]

Hi @natahoughton ,

Please refesh the data in power query as the picture below.

[PhilC · Accepted solution]

If there is a step where a table is expanded to display the columns, open that by clicking on the gear cog.  Do you see the two new colums in there?  If so, click the check box and they should now be avialable.

If not, how are you connecting to the data in the Excel file, via a Sheet, Table, Range?

Cheers

[Anonymous]

Can you please explain what did you mean by "where a table is expanded to display the columns, open that by clicking on the gear cog"? 

I have the same issue when I import several tables from a folder with the same number of columns and the same type of columns in each imported table. 

[natahoughton]

Thanks @PhilC , it worked!