How to Connect to Microsoft Planner from Power BI

[smjzahid]

How do I GET DATA from within PBI Desktop (June 2021) update to connect to Microsoft Planner,

Do we not have an easy way to do this may be using the web connector, or something else and schedule it for refrersh as and when any Bucket gets updated or new task gets assigned, PBI must pick those edited/new changes and show refreshed data.

I am not a global admin on my tenant, Therefore cannot make use of Microsoft Graph API's.

Note: I do have the PBI Service administrator role attached to my UPN

[v-stephen-msft]

Hi @smjzahid ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @smjzahid ,

Unfortunately Microsoft Planner has no connector for Power BI - this moment has mentioned in video https://youtu.be/pmzMljCT60A?t=238 You can use MS Planner API to build own application and collect data, or use ready solution that proposed in video - third-party system that collects data and exposes it as OData feeds.

Also you can use Flow instead.

Related articles are here:

https://techcommunity.microsoft.com/t5/planner-blog/microsoft-planner-considerations-for-reporting-8... 

https://techcommunity.microsoft.com/t5/planner-blog/microsoft-planner-considerations-for-reporting-p... 

Best Regards,

Stephen Tao

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