Forum Discussion
Solved
Creating a Copy of a Existing Report in Same Workplace
Hi everyone, I have a report linked to a semantic model which is linked to 3 excel files that live in a sharepoint site. I would like to create a copy of the report and simply change 1 of the lin...
Hi JC_24
You'll need to create a new semantic model. You could try these steps (assuming that V1 of the report is in the Service):
- Download the PBIX file from the Service (File > Download this file)
- Open Power Query (Transform Data)
- Select the query that relates to the Excel file you need to change
- Change the relevant query step to the new Excel file path/name
- Test the changes (should be simple if formats are the same)
- Save the file with a new name ...V2.pbix
- Publish to Workspace
MattB-Motive
Resolver I
Resolver IHi JC_24
You'll need to create a new semantic model. You could try these steps (assuming that V1 of the report is in the Service):
- Download the PBIX file from the Service (File > Download this file)
- Open Power Query (Transform Data)
- Select the query that relates to the Excel file you need to change
- Change the relevant query step to the new Excel file path/name
- Test the changes (should be simple if formats are the same)
- Save the file with a new name ...V2.pbix
- Publish to Workspace
This worked, thank you for your help MattB-Motive !