How to copy a report and point it at another data source with the same headers

[Adamadamadam]

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

[v-jiascu-msft]

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,

[Adamadamadam]

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

[v-jiascu-msft · Accepted 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,