Forum Discussion
Exporting the transforms and steps performed from PowerBI Desktop?
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!!!
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
1 Reply
- amitchandak
Super User
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