Forum Discussion

Tiolan's avatar
Tiolan
Frequent Visitor
9 years ago
Solved

Export query and changes to another pbix

Hello, Comunity.

 

After bringing a lot of data into PowerBI Desktop models and tables and adding a lot of complex DAX to transform it... 

How can I move all this stuff from one ".pbix" file to another, which also has a lot of implemented changes?

I need to move not data, but the query and transforming formulas, so new file can be updated from the original source.

 

I would appreciate any help with Idea and suggestions. 

 

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Tiolan,

     

    All the changes implemented when you import the data into model will display in the Power Query. You can select the table->Edit Query, you will get the Query Editor. In the Home window, select the Advanced Editor highlighted in red line, you will get the Query statement. In the new .pbix file, click Get Data->Blank Query, please copy and paste the Query statement, you will get the data and change it when you click Close&Apply. If the resource data table name is different, please replace it.



    After you import data table, you’d better copy the DAX formulas, and change the corresponding table name, filed. For the report in old .pbix file, we are not able to copy it to another .pbix file. We just create the new using similar method.

    If you have any question, please feel free to ask.


    Best Regards,
    Angelia

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Tiolan,

     

    All the changes implemented when you import the data into model will display in the Power Query. You can select the table->Edit Query, you will get the Query Editor. In the Home window, select the Advanced Editor highlighted in red line, you will get the Query statement. In the new .pbix file, click Get Data->Blank Query, please copy and paste the Query statement, you will get the data and change it when you click Close&Apply. If the resource data table name is different, please replace it.



    After you import data table, you’d better copy the DAX formulas, and change the corresponding table name, filed. For the report in old .pbix file, we are not able to copy it to another .pbix file. We just create the new using similar method.

    If you have any question, please feel free to ask.


    Best Regards,
    Angelia