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 del...
  • 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

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