Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RBOM12
New Member

Can I duplicate a report for another database?

Hello,

 

I'm new to Power BI and was wondering if it was possible to use the same report with two different databases? For example, I create a report and duplicate it, just changing the database but keeping the graphics.

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

@RBOM12 ,
Yes you definitely can.

You can create a copy of the report and directly change the DB from power query. If the structure of this new DB's table is different than existing one, you will have to make some changes to the visuals.
OR
Create a template file (.pbit) and use it in new report. Template will automatically keep the graphics.

View solution in original post

2 REPLIES 2
Anand24
Super User
Super User

@RBOM12 ,
Yes you definitely can.

You can create a copy of the report and directly change the DB from power query. If the structure of this new DB's table is different than existing one, you will have to make some changes to the visuals.
OR
Create a template file (.pbit) and use it in new report. Template will automatically keep the graphics.

GilbertQ
Super User
Super User

Hi @RBOM12 

 

Yes, this is possible if you open up your existing report, go file save as and save it with another name. Then, if you click on one like data hub and select power bi semantic models, you can then select your other model which you have uploaded to the power BI service and this report will now link to the different database or what is known as the semantic model.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors