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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sulmerj
Regular Visitor

Single Report with Multiple Pages or Multiple Report with One Page

I am working on creating a new externally facing Power BI application (Power BI embedded). This application MVP will be comprised of 10 "pages" or "reports" that the users will consume. Is it best practice (eg. best performance, maintenance, etc.) to have one Power BI report with multiple pages for each "report" or one report for each page. Or what are the pros/cons of each option? A team of 3 or 4 developers will be working on this project. The dataset size will be a few GB and will most likely be able to be used across reports (if we go that route). 

 

Thank you so much in advance!

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @sulmerj ,

Thanks for reaching out to us with your problem. Based on your description, it seems like you're trying to figure out the pros and cons of using one report but including multiple pages or using multiple reports. I think this may depend on your situation.

For single report that with multiple pages, if a report has grown to many pages, it might be too much to navigate through. You can apply report-level filters across all pages or sync slicers, use the drill-down feature, and maintain one data model. If you need to change something in the model, you only have to do it once. You can find more details in the following thread.

Solved: Multiple pages vs Multiple Reports - Microsoft Fabric Community

 

For multiple reports with one page each, if data modelers and report authors are different people, or if a model will be the source for multiple reports, now or in the future, it makes sense to separate model and report development into separate Power BI Desktop files. It is usually more usable to separate report files with fewer pages targeted towards specific needs...

Separate reports from models in Power BI Desktop - Power BI | Microsoft Learn

5 Tips for Separating Power BI Datasets and Reports — Coates Data Strategies

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

Hi @sulmerj ,

Thanks for reaching out to us with your problem. Based on your description, it seems like you're trying to figure out the pros and cons of using one report but including multiple pages or using multiple reports. I think this may depend on your situation.

For single report that with multiple pages, if a report has grown to many pages, it might be too much to navigate through. You can apply report-level filters across all pages or sync slicers, use the drill-down feature, and maintain one data model. If you need to change something in the model, you only have to do it once. You can find more details in the following thread.

Solved: Multiple pages vs Multiple Reports - Microsoft Fabric Community

 

For multiple reports with one page each, if data modelers and report authors are different people, or if a model will be the source for multiple reports, now or in the future, it makes sense to separate model and report development into separate Power BI Desktop files. It is usually more usable to separate report files with fewer pages targeted towards specific needs...

Separate reports from models in Power BI Desktop - Power BI | Microsoft Learn

5 Tips for Separating Power BI Datasets and Reports — Coates Data Strategies

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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