I have modified some data in power query. I have then loaded this data into a power pivot model (connection only).
I now want to be able to edit the model in power pivot but I am only allowed to edit using the power query interface.
Is it possible to copy the data that's in the power pivot and disconnect the model from power query all together. I've tried disconnecting but this will remove the model from power pivot.
Note: I need to use power query for preparation reasons and must use "connection only" as loading as a table would exceed excels row limit.