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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Workener
Frequent Visitor

Cannot connect to Office 365 Planner

Hello,

 

I try to connect to Office 365 Planner via Microsoft Graph, but the authentification fails, even if I'm global administrator. I can execute the queries within Microsoft Graph without any error messages, but in Power BI I cannot establish a connection.


Here are some queries that I've already tried:

https://graph.microsoft.com/v1.0/me/Planner/Plans

https://graph.microsoft.com/v1.0/Planner/Plans/<PLAN ID>/Details

 

As a source type I did select Web and OData, but both isn't working properly. As a login method I have chosen "Organizational Account". This is the error message I get:

2017-08-19 14_38_06-Unbenannt - Power BI Desktop.png

Other connection, e.g. to devices or users are possible!

 

Is it not possible to establish a connection in PowerBI to Planner in general?

 

Best regards,

Julian

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

@Workener,

 

Hi Julian,

 

It seems there isn't a solution by now. You could vote this idea: load-data-from-office-365-planner-to-powerbi.

Please reference the similar posts: Is-it-possible-to-get-the-planner-task-from-Microsoft-Graph.

 

Best Regards!

Dale

Community Support Team _ Dale
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

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

@Workener,

 

Hi Julian,

 

It seems there isn't a solution by now. You could vote this idea: load-data-from-office-365-planner-to-powerbi.

Please reference the similar posts: Is-it-possible-to-get-the-planner-task-from-Microsoft-Graph.

 

Best Regards!

Dale

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

I figured out how to do this but it's definitely a work around. I'm using Microsoft Flow to setup an if this then that logical steps. I set it up to do this: When new taks is created, then insert row into excel table in OneDrive for Business. I have tested it and it has been working. I'm now setting up an "Update" flow.. I hope that helps. If you need more info then message me or reply here. Here is the link tot he flow I created succesfully. Alternatively, you could try to write this data to a sql database in azure if the option exists, which i think it does. I also saw there is an option for BLOB storage, but a table is the simplest method.

 

Update: Currently planner does not have the "Update" trigger so it almost makes this uesless if you want to see any adjustments to your task.. This somewhat defeats the purpose, but it is a work in progress.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.