Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi guys,
What I have is an excel file with multiple sheets, each sheet has data for a location with the same headers mostly, what I want to do is copy a report, so that the visualisations etc don't need to be remade, into a new page of a report, and then change the data source and point my visualisations at the other source sheet.
Is this easily possible, and if so how do I go about this? Thanks.
Adam
Solved! Go to Solution.
Hi Adam,
You can easily copy a page. But you have to change the fields of each visual manually for now. If you copy the whole report as a new report (the .pbix file), you can change the data source in the Query Editor. In this case, you don't need to modify the visuals.
Best Regards,
Hi Adam,
If you'd like to copy the whole report and change the data source, that would be easy. I'm afraid it's hard to change the source of visuals to other queries (tables). I would suggest you vote up this idea.
Best Regards,
Thanks.
Would I be able to copy the whole report onto a new page? and then change the data source for that page to the new table, as the source for all visualisations?
Regards,
Adam
Hi Adam,
You can easily copy a page. But you have to change the fields of each visual manually for now. If you copy the whole report as a new report (the .pbix file), you can change the data source in the Query Editor. In this case, you don't need to modify the visuals.
Best Regards,
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |