Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,