Skip to main content

Power BI

New

Create multiple reports in a single Power BI Desktop file

Vote (57) Share
Dan's profile image

Dan on 24 Dec 2015 18:30:20

We are creating multiple reports for a single dataset so any changes to measures are done in a single location and we are forced to do subsequent reports via the Service. Would be great if we could edit multiple reports in a single desktop file.

Comments (7)
Dan's profile image Profile Picture

cda7cf3e 2f0c-419e-a204-4bc4c12dc75d on 05 Jul 2020 23:36:02

RE: Create multiple reports in a single Power BI Desktop file

I appreciate that you can edit a report and do a 'save as' but then any changes to the master may need to be carried through to the child reports. Being able to reference a data set in the Power BI Service would be perfect.

Dan's profile image Profile Picture

72f47a51 92a7-ea11-a812-000d3a579c34 on 05 Jul 2020 23:11:44

RE: Create multiple reports in a single Power BI Desktop file

hope they put this at the top of their list!

Dan's profile image Profile Picture

0d5c2f85 2627-46b7-ab5b-6d84d2bf7568 on 05 Jul 2020 23:02:11

RE: Create multiple reports in a single Power BI Desktop file

Actually, I believe I did find a work around. Basically, I just clicked "Edit Report" on the Power BI service. Then modified it as I want, and click "Save As" to create a copy of that report.

So, Say I have a PBIX file called "Data Model 1". It has 3 tabs in the report (Tab 1, Tab 2, Tab 3). I publish the PBIX up to the service.

On the service, I now have 1 data model and one report titled "Data Model 1" that has the three tabs within it. I now open that report and click "Edit Report" and then "Save As" and call it "Report 1". I then delete from that report tabs 2 & 3. I now have 2 reports on the service, "Data Model 1" and "Report 1". I can repeat for tabs 2 & 3 if I like and finally delete the original report. Now all I have is "Report 1, 2, & 3"

The trick will be when I change the data model in the PBIX file and republish I have to do all this again, but at least it appears to be a work around. Hope this was helpful to someone.

Dan's profile image Profile Picture

340b7eab f359-4fd4-b368-1ef521f249b7 on 05 Jul 2020 22:55:59

RE: Create multiple reports in a single Power BI Desktop file

We probably don't need this idea anymore as Power BI Desktop can connect to models on the powerbi.com service,

Dan's profile image Profile Picture

81ce4dee 9a3a-4f38-98cd-2bc49c0c5fa2 on 05 Jul 2020 22:42:45

RE: Create multiple reports in a single Power BI Desktop file

I definitely agree with this. In addition to this, being able to download the collection of reports along with the single dataset as a pbix file for pbi desktop. I currently use tabs in a single pbix file to deal with this. I am just watching the elegance of my report fade away as I continue to iterate.

I am starting to wonder others have a great workaround to this due to the low vote count for this idea. Please let me know what the solution is.

Dan's profile image Profile Picture

d7f24786 b146-4b91-9a05-8b2da1860210 on 05 Jul 2020 22:21:11

RE: Create multiple reports in a single Power BI Desktop file

Like most other popular office programs, you should be able to go to "Open Recent" in the PowerBi desktop file and choose what report for that dataset you want to be working on.

Dan's profile image Profile Picture

f77c3028 94f3-4f21-89fa-e9024911bfbc on 05 Jul 2020 22:17:01

RE: Create multiple reports in a single Power BI Desktop file

Please, Please, Please, ... otherwise is nigthmare to create content from the same dataset.