Easiest way to copy an entire pbix report

[smpa01]

I have a pbix refrencing multiple data sources with a start schema for data model and 100+ Measures with 3+ DAX derived tables.

There is an issue with the report that it works in workspace but fails in embedding.

I need to replicate the whole report in a new report altogether to test out that it is not due to any metadata issue.

My

primary question - what is the easiest way to copy all the measures?

secondary question - Is there a way to copy (rather than manually) all the data sources and data model too?

                                 - Is there any way to copy the viz too? (have over 5 tabs of viz, would be a pain for me to manually

                                                                                                create them again)

[negi007 · Accepted solution]

@smpa01 to copy all the measures, you can also use dax studio. You will be able to view all dax measure code in the dax studio or dax tablaur editor and then you can copy and paste it to your new pbix file to simply create all measures

https://www.inkeysolutions.com/blogs/power-bi-how-to-easily-copy-measures-from-one-pbix-file-to-anot...

https://community.powerbi.com/t5/Community-Blog/Bulk-measure-handling-copy-between-reports-format-ch...

hope this will reduce your some of task of copying and visuals you can simply copy and paste between two pbix files

[negi007]

@smpa01 so i assume you dont have the pbix file else you would have simply created a new copy.  what is the challenge that you are facing in that.

also see if below links helps you

https://www.inkeysolutions.com/blogs/power-bi-copy-visuals-to-another-pbix-file/

https://community.powerbi.com/t5/Desktop/Copy-report-page-from-PBIX-to-another-PBIX/m-p/800887

[smpa01]

@negi007 

assume you dont have the pbix file else you would have simply created a new copy - I do have the pbix and I don't want to simply make a copy (so that I don't carryover the bad metadata issue if any).