How to modify a power query file AFTER it has been imported into Power Pivot

[Glaglagla]

Hello there!

I made a big mistake and I don't know how to get out of it:
I import .csv file into Power Query to modify the file and then import it into Pivot.
For very stupid reason (I wanted to be very quick on a analysis and used an excel formula, because I couldn't find the way to do it into query or pivot), I added a column into my csv file. This column is named "nb occurence".
Now that I found the way to create this column directly into Power Pivot, I deleted the column into the csv file, and deleted it from the power Query request BUT I cannot charge the file into Pivot because Pivot find that the file has been modified and doesn't recognize it. Excel recommend me to delete the connection and re create it.
BUT I already built all my analysis and calculates colums and fields and really really don't want to do it all over again.

Any idea?

 

[scottsen]

The interplay between PQ and PP gets wonky pretty quick... so, no idea if this will work. No harm trying though.

I would try to deselect the column in Power Pivot first. Then delete from PQ, and refresh?

On the bright side, if you have to do over... the calc columns in PP... you really PREFER them to be in PQ (for minor perf reasons). The measures you can move to another table (though, its a minor pain, at least you don't have to re-type) in the measure edit dialog.

 

[Glaglagla]

Hey,

Thanks for the quick reply. Stupid question: where is it that I can unselect a column?

 

[scottsen]

Table Properties. At least... that works for csv and sql and... I'm assuming it works for PQ