Forum Discussion

natahoughton's avatar
natahoughton
New Member
7 years ago
Solved

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

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!

Need Help
  • PhilC's avatar
    PhilC
    7 years ago

    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

4 Replies

  • PhilC's avatar
    PhilC
    Resolver I
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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.