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

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.