cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nilesh_shirsat Regular Visitor
Regular Visitor

Multiple reports using single Power BI Desktop file

Hi All,

In Power BI Service we can create multiple reports using single dataset/data connection.
All reports are tied to only one dataset.

 

How to achieve same using Power BI Desktop ? can we create multiple reports using one dataset/data connection in single PBIX file ?


One way could be creating single report in PBIX and publish it , then use same dataset connection for new reports but in Power BI Service.But in this way I will not be able to utilize more features available in Power BI Desktop.

 

Thanks, Nilesh

5 REPLIES 5
Nhallquist Member
Member

Re: Multiple reports using single Power BI Desktop file

Great question.  One thing that I have been thinking about, and doing some testing, is something along this scenario.  Have you used the Dashboard yet?  When you publish a report to app.PowerBI.com, you can Pin objects to a dashboard.  The first time, you create the Dashboard.  When you go to publish the next report, you can pin objects to a dahsboard, and you can choose which dashboard.  Try pinning multiple objects from multiple reports to the same dashboard.  The objects are not live, but this might get you what you are looking for.

 

Nate

kcantor Super Contributor
Super Contributor

Re: Multiple reports using single Power BI Desktop file

The majority of my reports come from a single source file. I simply create multiple pages within that report and pull them apart on powerbi.com and save them as separate reports. My source file has about 30 pages but the reports average about 5 each. Many reuse the same page but have changes saved from the app.

To add more calculations I simply replace the source file prior to an update.



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

Proud to be a Datanaut!




Vicky_Song Established Member
Established Member

Re: Multiple reports using single Power BI Desktop file

Yes, it is possible for you to create multiple reports connect to one dataset in Power BI Desktop. The very first thing for you is to connect to Data in Power BI desktop, then you can connect to the same dataset when you work with different reports in Power BI Desktop. 

Highlighted
mauropasi Regular Visitor
Regular Visitor

Re: Multiple reports using single Power BI Desktop file

I don't think the moderator understood the question. The answer did not help at all.

Ged Regular Visitor
Regular Visitor

Re: Multiple reports using single Power BI Desktop file

How do you 'pull them apart'? I have my PBIX source file with multiple pages in there. I would like to splitthem apart when I publish the file to my workspace. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 346 members 3,941 guests
Please welcome our newest community members: