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

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

 

  • powerbiexpert22's avatar
    powerbiexpert22
    Impactful Individual
    2 years ago

    Hi PijushRoy 

    Is there a way to do without copy paste?