{"id":385,"date":"2023-01-07T17:31:03","date_gmt":"2023-01-07T17:31:03","guid":{"rendered":"https:\/\/monocroft.com\/?p=385"},"modified":"2023-01-07T17:56:10","modified_gmt":"2023-01-07T17:56:10","slug":"duplicate-power-bi-reports","status":"publish","type":"post","link":"https:\/\/monocroft.com\/duplicate-power-bi-reports\/","title":{"rendered":"How to Duplicate Power BI Reports Using the Same Dataset"},"content":{"rendered":"\n
Do you want to know how to duplicate Power BI reports while using the same data set? This article explores an easy approach to doing that.<\/p>\n\n\n\n
Read to learn more.<\/p>\n\n\n\n
To start with, you will open a fresh Power BI desktop window on your computer. This is where you will paste your report duplicate. It is automatically “untitled.”<\/p>\n\n\n\n After this, go back to your report window (where your report is). To avoid confusion, I will advise creating a new page, and you can do this by clicking the plus (+<\/strong>) sign.<\/p>\n\n\n\n Make sure you are on the home tab. Click the dropdown on Transform data, and select Transform data.<\/p>\n\n\n\n This will automatically take you to Power Query Editor (as displayed below).<\/p>\n\n\n\n In the power query editor, right-click one of the queries, and select advanced editor. <\/strong><\/p>\n\n\n\n This will take you to the advanced editor (where all your codes are stored) for that particular query you selected. <\/p>\n\n\n\n Here, you will select all the codes<\/strong> (Ctrl + A), and copy it all (Ctrl + C).<\/strong><\/p>\n\n\n\n Now, open your new Microsoft Power BI window. Go to Transform data<\/strong>, and it automatically takes you to the Power Query Editor window (as you can see below). <\/p>\n\n\n\n On the left side of the canvass, right-click and select “Blank Query”<\/strong><\/p>\n\n\n\n This will automatically take a blank query (as displayed below). Here, you will delete the content in the advanced editor, and paste the query you copied from your Power BI report.<\/p>\n\n\n\n After pasting the query, check if there is a syntax error. In the absence of none, that means you are good to go. Click Done.<\/strong><\/p>\n\n\n\n Yes, your old report has been duplicated in a new power BI desktop window. <\/p>\n\n\n\n NB: You can rename the newly-created query by right-clicking it, and selecting “Rename.”<\/strong><\/p>\n\n\n\n Now, you have just learned how to duplicate reports using the same dataset in Power BI Desktop.<\/p>\n\n\n\n NB: You can repeat this same process for other queries in your reports.<\/p>\n\n\n\n Thanks for reading.<\/p>\n","protected":false},"excerpt":{"rendered":" Do you want to know how to duplicate Power BI reports while using the same data set? This article explores … <\/p>\n<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Conclusion: How to Duplicate Power BI Reports Using the Same Dataset<\/h2>\n\n\n\n