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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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
kcantor
Community Champion
Community Champion

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 Super User!




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. 

Vicky_Song
Impactful Individual
Impactful Individual

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. 

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

Nhallquist
Helper V
Helper V

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors