Hello,
I have some Data, that I like to transform. Is it possible to import Data from PowerPivot to PowerQuery and then back again?
Before the transformation, the Data however needs to be connected and changed using PowerPivot. First because there is a relation between the tables (and the identifier has to be calculated first) and it is very computation intensive. Also, I want to import my raw Data once into Powerpivot and let formulas do everything automatically. I do not want to download my PowerPivot Data and import it to PowerQuery to then send it to PowerPivot.
How can I do this?
I have some Data, that I like to transform. Is it possible to import Data from PowerPivot to PowerQuery and then back again?
Before the transformation, the Data however needs to be connected and changed using PowerPivot. First because there is a relation between the tables (and the identifier has to be calculated first) and it is very computation intensive. Also, I want to import my raw Data once into Powerpivot and let formulas do everything automatically. I do not want to download my PowerPivot Data and import it to PowerQuery to then send it to PowerPivot.
How can I do this?
