Forum Discussion

Adamadamadam's avatar
Adamadamadam
Frequent Visitor
7 years ago
Solved

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

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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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,

Adamadamadam's avatar
Adamadamadam
Frequent Visitor
7 years ago

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's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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,