Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
This topic has already been discussed (https://community.powerbi.com/t5/Desktop/Copy-a-Report-Page-from-pbix-to-another/td-p/25877), but I have a different version of the question:
I have 2 different .PBIX files. They both use the SAME datasource. One is the Master copy, and one is a development copy that another team member was using to create some new reports. I need to bring the new reports into the Master.
Is this functionality avaiable, or do I have to recreate the reports in the Master from scratch?
Note that this is basic copy/paste funtionality in Tableau, it would be nice to see the same in Power BI.
Solved! Go to Solution.
@Anonymous
If they have the same data source you can
Add a blank page in your target .pbix
Go to your source .pbix and with nothing selected on the report page hit CTRL + A (select all). Then CTRL + C (copy).
Go to your target report and on blake page CTRL+V
@Anonymous,
I assume you mean to copy all the visuals from one report to another, in that case you could just do Ctrl+C and Ctrl+V as long as all the column names are the same.
And also if you do CTRL-C CTRL-V visual order does not be the same as the source. And both the size and position of visuals can differ from origin
@Anonymous,
I assume you mean to copy all the visuals from one report to another, in that case you could just do Ctrl+C and Ctrl+V as long as all the column names are the same.
@Anonymous
If they have the same data source you can
Add a blank page in your target .pbix
Go to your source .pbix and with nothing selected on the report page hit CTRL + A (select all). Then CTRL + C (copy).
Go to your target report and on blake page CTRL+V
This has worked well for me in the past, but in some recent strange cases it seems I need to add a random visualization to the blank page before pasting...
THANK YOU 😅
Thank you very much tah, I have always done the Ctrl + A, Ctrl + C Ctrl + V from one report to the next, today, for the first time ever, it wouldn't work. Your trick solved it!! Thank you from Costa Rica!!
@jdbuchanan71 while Ctrl A + Ctrl C copies all visuals and slicers across, it does not transfer filters applied on a page level.
Unfortunately this copies only the Visuals, and not the filters, so this is not a full solution. I hope that PowerBI will soon be equipped with such a basic function as copying pages from one file to another.
I found that CTRL-A (select all), CTRL-C (copy) and then CTRL-V (paste to new pbix) brings over both the visuals and the slicers (filters), just as jdbuchanan71 noted above.
I wonder what version of Power BI you are using, if its not bringing over the slicers?
Unfortunately CTRL+A +C and then +V only copies the visuals... so like you said also the Slicers.
But it does not copy the (hidden) Page filters.
It also does not copy any Quick Measures you may have defined and used in the visuals in the source report.
Currently, you need to recreate/reapply all these manually in the destination report.
Thank you all for the quick reply. I did a search in these forums and was not able to find this solution.
I am a long-time Tableau user but new to Power BI. Your suggested solution worked exactly as described.
Thanks again.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
104 | |
65 | |
64 |