Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |