Common transformations

[powerbiexpert22]

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

[CoreyP · Accepted solution]

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

[PijushRoy]

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]

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 · Accepted solution]

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

[CoreyP · Accepted solution]

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

[PijushRoy]

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]

Hi @PijushRoy 

Is there a way to do without copy paste?