How to View All Microsoft Project Plans on One Dashboard
Question details
The user wants to find a way to view multiple Microsoft Project plans consolidated into a single portfolio dashboard.

- Product
- Microsoft Project, Power BI
- Device & OS
- not provided
- Scenario
- Generating high-level, cross-project portfolio reporting for better project tracking and management.
- Observed behavior
- Microsoft Project desktop alone does not provide a built-in portfolio dashboard to view across all projects natively.
Ensure you have access to Power BI Desktop and know the URL for your Project Online Web App (PWA) or Microsoft Dataverse environment where your project data is stored.
Use the Power BI Report Pack for Project Online
If you are managing your tasks in Project Online, connect your data to Power BI to generate comprehensive cross-project dashboards.
Microsoft provides a dedicated Power BI template designed to seamlessly extract and visualize portfolio data from Project Online.
Navigate to the Microsoft Download Center or AppSource and download the free Power BI Report Pack for Project Online.
Launch your Power BI Desktop application and open the newly downloaded template file.
When prompted by the template, enter your Project Online PWA (Project Web App) URL to authenticate and pull your portfolio data into the dashboard.

Apply the Power BI Template for Project for the web
For users managing their schedules via Project for the web, a specific Power BI template is available to consolidate project reporting.
Create Project Dashboards with WPS Office
If setting up Power BI integrations for Microsoft Project seems complex or costly, WPS Office provides a free, lightweight, and easy-to-use alternative. With highly customizable spreadsheet templates, you can easily track project timelines, collaborate with your team, and maintain full compatibility with Microsoft Excel formats without the heavy licensing costs.
- 1. Install WPS Office: Download and install the free WPS Office suite on your PC or mobile device.
- 2. Open WPS Spreadsheet: Launch the WPS Spreadsheet application to begin organizing your project tracking data.
- 3. Use a Project Template: Click on 'New', search for 'Project Dashboard' or 'Gantt Chart' in the template library, and apply a free template to track your tasks instantly.

Frequently Asked Questions
Can I view all my projects on one dashboard using Project Desktop alone?
No, Microsoft Project Desktop does not include a built-in portfolio dashboard for cross-project reporting. You need to use Project Online or Project for the web combined with Power BI.
Are the Power BI report packs for Microsoft Project free?
Yes, Microsoft provides the Power BI report packs for both Project Online and Project for the web as free downloads, though you may need a Power BI Pro license to publish and share the dashboards with your team.
Where can I find the links to download the report packs?
You can find the Power BI report packs by searching the official Microsoft Download Center or Microsoft AppSource for 'Power BI Report Pack for Project Online' or 'Project for the web'.




