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

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.