How can I link to planner instead of project in my PowerBI dashboard?

Question

How can I link to planner instead of project in my PowerBI dashboard?

Jessica Cella 20

I am wondering how to easily connect MS Planner and PowerBI. I am currently using a PowerBI template that links MS Project Online and PowerBI. Since Project Online went away, the links to the plans/projects no longer work. How can I automate linking to the planner page instead of the broken Project Online site.

0 comments

Answer accepted by question author

Francisco Montilla 30,700 Independent Advisor

Hello,

It sounds like you are hitting a wall because the Premium plans (formerly Project for the Web) live in a completely different database than the Basic plans. The standard Power BI Planner connector typically only sees the Basic ones, which is why your Premium data is missing.

Premium plans are stored in Dataverse. To report on them and generate the correct links to the new Planner interface, you need to use the Dataverse connector in Power BI, not the Planner one.

Do you have access to your Power Platform Environment URL (usually found in the Power Platform Admin Center)? If you can grab that URL, I can walk you through exactly which tables to pull and the formula to build the new links.

Angela Digmann 0 Reputation points

2026-01-27T19:13:22.3933333+00:00

Thank you @Francisco Montilla ! I work with @Jessica Cella and I believe we do have our URL (in the format of: https://org########.crm.dynamics.com/ ) - does that sound correct?
Jessica Cella 20 Reputation points

2026-01-29T16:24:09.1833333+00:00

Hello Francisco, Angela does work with me, is that the correct url format? We'd so appreciate your support!
Francisco Montilla 30,700 Reputation points Independent Advisor

2026-01-30T18:52:47.7266667+00:00

Hello Angela and Jessica,

I'm sorry, I think only OP replies reach my notifications.

Yes that URL format is exactly what you need to connect to the Dataverse instance.

Open Power BI Desktop and choose Get Data then select Dataverse. Paste that URL you found into the Environment domain field and click OK. In the Navigator search for the table named msdyn_project. This table contains the Premium plans that the standard Planner connector hides. Select it and click Load.

Once that table is in your report you can build the dynamic link. Create a new Calculated Column that combines the standard Project for the Web URL prefix with the msdyn_projectid column from that table.

If you open one of your plans in a web browser you can copy the first part of the URL to see exactly what prefix your organization uses. Let me know if you see the list of projects populate after connecting.
Jessica Cella 20 Reputation points

2026-02-13T17:04:13.0933333+00:00

FRANCISCO You are A GENIUS!!!! I was able to get it to work and I feel so proud of myself, but wouldnt have been able to do it without you!

2 additional answers

Your answer

Angela Digmann 0 Reputation points

2026-01-27T19:13:22.3933333+00:00

Thank you @Francisco Montilla ! I work with @Jessica Cella and I believe we do have our URL (in the format of: https://org########.crm.dynamics.com/ ) - does that sound correct?
Jessica Cella 20 Reputation points

2026-01-29T16:24:09.1833333+00:00

Hello Francisco, Angela does work with me, is that the correct url format? We'd so appreciate your support!
Francisco Montilla 30,700 Reputation points Independent Advisor

2026-01-30T18:52:47.7266667+00:00

Hello Angela and Jessica,

I'm sorry, I think only OP replies reach my notifications.

Yes that URL format is exactly what you need to connect to the Dataverse instance.

Open Power BI Desktop and choose Get Data then select Dataverse. Paste that URL you found into the Environment domain field and click OK. In the Navigator search for the table named msdyn_project. This table contains the Premium plans that the standard Planner connector hides. Select it and click Load.

Once that table is in your report you can build the dynamic link. Create a new Calculated Column that combines the standard Project for the Web URL prefix with the msdyn_projectid column from that table.

If you open one of your plans in a web browser you can copy the first part of the URL to see exactly what prefix your organization uses. Let me know if you see the list of projects populate after connecting.
Jessica Cella 20 Reputation points

2026-02-13T17:04:13.0933333+00:00

FRANCISCO You are A GENIUS!!!! I was able to get it to work and I feel so proud of myself, but wouldnt have been able to do it without you!

Answer 1

kagiyama yutaka 4,920

hello Jessica Cella,

yeah, I know this switch can feel a bit shaky… a lot of folks hit the same thing when Project Online disappeared. in my experience, Planner just doesn’t give u the clean OData feed the old template relied on, so the connection kinda falls apart. most teams end up pulling Planner through Graph API or dropping it into Dataverse with a small flow. once that’s in place, PowerBI behaves pretty steady again.

0 comments

Answer 2

Jessica Cella 20

I did find an article online for connecting, but was unable to connect more than one plan and it was only showing basic plans, not premium. Please help! We are using Planner for our whole team and need a dashboard with the data, and the ability to connect back to the plan for more detail.

0 comments