Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago
Solved

Common transformations

I want to reuse common power query transformations in another pbix file , is there a way to do it without using dataflow? 

Need Help
  • CoreyP's avatar
    CoreyP
    2 years ago

    Publish File1 to the Power BI service. Open File2 in Power BI Desktop. Get Data > Datasets > File1

  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi powerbiexpert22 

    Step 1 - Publish the report/PBIX1 file in Power BI Service
    Step 2 - Open new pbix file and follow the below step

    Step -3 - Select the PBIX1 Dataset and start building PBIX2 report

     

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS

    Thanks
    Pijush

6 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi powerbiexpert22 

    Right click on table in Power Query and copy
    Then paste the query in new pbix file. Table will copied with steps

     

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS

    Thanks
    Pijush

     

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi powerbiexpert22 

    What is the objective or scenario, can you please describe more?

    Process you can follow

    1. Save a Copy of the Report:
    • Open the report in Power BI Desktop that is associated with the dashboard you want to duplicate.
    • Go to the ‘File menu’, then select ‘Save As’.
    • Give the report a new name and save it to your desired location.
    • Delete visual and power query table which is not require for new pbix file
    • Save the file

     

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS

    Thanks
    Pijush

    • powerbiexpert22's avatar
      powerbiexpert22
      Impactful Individual
      2 years ago

      Example:

      File1.pbix

      Dim1,Dim2,Dim3,Dim4,Dim5,Fact1

      File2.pbix

      Dim1,Dim2,Dim3,Fact2

      I want to reuse Dim1,Dim2,Dim3 from File1.pbix in File2.pbix

      • PijushRoy's avatar
        PijushRoy
        Community Champion
        2 years ago

        Hi powerbiexpert22 

        Step 1 - Publish the report/PBIX1 file in Power BI Service
        Step 2 - Open new pbix file and follow the below step

        Step -3 - Select the PBIX1 Dataset and start building PBIX2 report

         

        If solved your requirement, please mark this answer as SOLUTION.
        If this comment helps you, appreciate your KUDOS

        Thanks
        Pijush