Forum Discussion

PeterBI's avatar
PeterBI
Helper I
10 years ago
Solved

Excel Import and a new column

Hello,

After an Insert a new colum in my Excel File i get an Error whil actualize the data. What i have to do, to insert this new column in PowerBI.

Kind Regards, Peter

Need Help
  • SamLester's avatar
    SamLester
    10 years ago

    Is "Column79" the column you are adding or something that is giving problems during the refresh? Can you click on "Edit Queries", then right-click the query, select "Advanced Editor" to view the columns used in the query? Is Column79 referenced in there? If so, can you remove it if it is unnecessary and then try to refresh?


    Thanks,
    Sam Lester (MSFT)

4 Replies

  • SamLester's avatar
    SamLester
    Microsoft Employee
    10 years ago

    Hi Peter, the basic steps are:

     

    1. Import .xlsx file into Power BI Desktop using "Get Data"

    2. Update the spreadsheet, add another column

    3. Back in Power BI Desktop, click on the Refresh button

     

    This will load the new column into the data model in PBI Desktop.

     

    If you are doing this and hitting an error, please provide the exact steps and error message that you are receiving.


    Thanks,
    Sam Lester (MSFT)

     

    • PeterBI's avatar
      PeterBI
      Helper I
      10 years ago

      Hello Sam,

      thanks for your fast reply.

       

      i did Step 1-3 and then i get the following message: Did not find Column79.

      • SamLester's avatar
        SamLester
        Microsoft Employee
        10 years ago

        Is "Column79" the column you are adding or something that is giving problems during the refresh? Can you click on "Edit Queries", then right-click the query, select "Advanced Editor" to view the columns used in the query? Is Column79 referenced in there? If so, can you remove it if it is unnecessary and then try to refresh?


        Thanks,
        Sam Lester (MSFT)