Forum Discussion

car16's avatar
car16
New Member
7 years ago
Solved

Deleting Data from Excel Source & Refreshing in Power BI - Causes Errors - Why?

Does anyone know if it's possible to delete columns of data from the excel source file (that I have uploaded into Power BI) after the fact?  I have several columns that are not needed, but when I delete them from excel and refresh Power BI and error occurrs saying "the data is missing".  If I delete the same columns from the Power BI file (through edit queries) I still receive the same error.

 

Thoughts?

  • Vvelarde's avatar
    Vvelarde
    7 years ago

    car16

     

    Hi, this a common error.

     

    Go to Edit Query and find the Changed Type Step . Review it and delete the columns that you desire. (the same that you erase in the source)

     

    Regards

     

    Victor

4 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    7 years ago

    car16

     

    Hi, this a common error.

     

    Go to Edit Query and find the Changed Type Step . Review it and delete the columns that you desire. (the same that you erase in the source)

     

    Regards

     

    Victor

    • car16's avatar
      car16
      New Member
      7 years ago

      Vvelarde

       

      Thank You!  Easy fix, just something I was not aware of in Power BI (we are just starting to use this more heavily at my company, so learning as I go).  Appreciate it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I wish it worked for me.

         

        It never does. 

         

        I end up having to redo all my tables.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi car16,

     

    If you directly delete the column in source file, the update won't be applied to Power Query automatically when you refresh dataset, Power Query will prompt "Connot find column" error. To resolve this error, please delete the corresponding column in Power Query, either. In below example, I delete column [Financial_Year].

     

    Best regards,

    Yuliana Gu