Forum Discussion

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?

CoreyP
2 years ago
Publish File1 to the Power BI service. Open File2 in Power BI Desktop. Get Data > Datasets > File1
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

Community Champion

2 years ago

Hi powerbiexpert22

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

Process you can follow

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

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
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
CoreyP
Solution Sage
2 years ago
Publish File1 to the Power BI service. Open File2 in Power BI Desktop. Get Data > Datasets > File1