Exporting the transforms and steps performed from PowerBI Desktop?

[Anonymous]

Ive scoured youtube and google and its like drinking water through an open firehose. Nothing I am finding is working for me. 

I have a powerBI file with dozens of tables.. many are references of others.. many are pointing to autoarchiving folders...

I wish there was a way to export a table with the Query Settings, Applied steps so that I can import that into another powerBI pbix file. Surely Im not the first person to ever need to do this??

I have work that took hours and days to build in one pbix... and those features must be completely repeated in a new pbix file if I want to integrate the same table features/functions in another pbix file. 

please tell me how I can do this and get half my life back. 

thanks!!!

[amitchandak · Accepted solution]

@Anonymous ,The option I can think of

We publish the power bi file, and then we will two files. Dataset and report. We can dataset as live or direct query source:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

In place of power query, we use dataflow, which will make it available easily across the pbix

Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA

From the Data tab(DAX), You right click and copy paste table in excel

From the Power query just copy and paste into another power query(another pbix) , you will get complete code, data will be loaded again