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 t...
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

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.