Forum Discussion

ttleonard's avatar
ttleonard
New Member
2 years ago

Power BI doesnt refresh when a new column is added

Hi everyone,

I added column D in an Excel sheet.

Power BI shows an error

Below are the steps I did to transform data before adding a new column.

 

Could you please advise the solution? 

Thank you

Trang Leonard

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    ttleonard , seems like column 50 is not found, it has been used in the rename, or change type step, which is causing that.

    Check the steps and remove the reference of the column

    • ttleonard's avatar
      ttleonard
      New Member
      2 years ago

      Can you kindly be more specific? Which step should I remove or modify? 

      • lizzy's avatar
        lizzy
        Icon for Helper I rankHelper I
        2 years ago

        Look in your "Change Type" step. It probably references a column by a name that it doesn't have anymore. The way in general to figure this out is click on each step one by one and see where the error begins.

  • ttleonard's avatar
    ttleonard
    New Member
    2 years ago

    Hi everyone,

    Can anyone kindly assist me with my question? 

    Thanks

    Trang