Blog Post
Manage multiple plans effortlessly with the new Portfolios feature in Microsoft Planner
Almost useful... a few more features, please. Without these, we aren't really managing portfolios but rather just viewing them in an akwardliy limiting way. Your Planner service is so easy to start with but fails quickly at even moderate scale.
- Bring into the grid view: planned effort, remaining effort, projected end date
- Add totals... grids without totals are less useful
- Add an export button... excel or CSV
- Add a basic dashboard tab like we have for individual plans
- Give us a connector for power apps so we can make reports and dashboards
Happy to talk to anyone there about these. I'd consider them basic tables stakes features for project management tools. You are so close and already on about everyone's enterprise desktop... let's finish already. I'd rather have actual portfolio management than copilot buttons. Hard to justify more seats when other services do this well and completely.
Hi there Nick, FYI you can do the majority of what you are looking for above (1-5) in the Planner Power App.
- The Power App provides this with basic setup
- This can be done in the Power App or a Power BI report
- This can be done in a Power BI report, exporting the visuals and/or the data
- The Power App, build a dashboard with Power BI
- It's already there, all the data in Planner premium (the source of data in the Portfolio) is stored in the Microsoft Dataverse database, and is available for reporting using Power BI
Happy to share some examples if you'd like to see them?
- kefir_osJul 09, 2025Copper Contributor
Hi robhprojility, can you please provide more details re 5? I cannot find the my portfolio data (portfolio, project statuses) anywhere in the Dataverse.
- icetswSep 08, 2025Copper Contributor
Hi robhprojility I'm having the same challenge as you in locating the Portfolio data object. No problem with the other Planner data, just cant seem to find the Planner Portfolio data in Dataverse in PowerBI. Did you manage to find yours?
- robhprojilityJul 09, 2025Brass Contributor
Hi, there's a pretty good Microsoft article on finding your Dataverse database here: https://learn.microsoft.com/en-us/project-for-the-web/handling-data-for-project-for-the-web-and-roadmap
You may want to work with your Office 365 administrator to determine if it's all in the 'default' environment (where projects in Planner premium are stored natively when you first start the service), or if they setup a 'named environment' just for you and your team, which would have setup a separate Dataverse database for your data.
- stamaApr 09, 2025Copper Contributor
Hello robhprojility can you share how you created #4? I have about 8 different Projects and it is difficult to remember where a task was created. The search feature is only with one Project.
- Nick_1020Mar 31, 2025Copper Contributor
Yes, please. But if it's the suite of power apps that already exist, those are available at the 5 subscription level and felt unfinished or unmaintained last time I checked, mid '24. Should be basic UI the web app, not custom-built integrations. The Planner app has seen so many welcome updates, why not natively? Would love to talk...