Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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:
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
Solved! Go to Solution.
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
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
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.
User | Count |
---|---|
24 | |
21 | |
11 | |
11 | |
10 |
User | Count |
---|---|
50 | |
31 | |
20 | |
18 | |
15 |