Looking for to establish Planner connection with PowerBI

%3CLINGO-SUB%20id%3D%22lingo-sub-1505148%22%20slang%3D%22en-US%22%3ELooking%20for%20to%20establish%20Planner%20connection%20with%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505148%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%2C%3C%2FP%3E%3CP%3EI'm%20required%20to%20design%20Power%20BI%20dashboard%20for%20Planner%20tasks%20but%20I%20am%20not%20able%20to%20connect%20the%20Planner%20data%20source%20with%20PowerBI.%20Therefore%2C%20I%20am%20keen%20to%20establish%20connection%2Fdata%20source%20with%20Planner%20in%20PowerBI%20to%20automate%20the%20Planner%20data%20i.e.%20tasks%20so%20on.%20Instead%20of%20exporting%20data%20all%20the%20time%2C%20my%20company%20want%20me%20to%20automate%20it%20by%20using%20of%20Power%20automate(trigger)%20or%20any%20other%20service.%20Can%20someone%20help%20me%20out.%3C%2FP%3E%3CP%3EIt%20will%20be%20appreciated%20to%20share%20the%20knowledge.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1505535%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20to%20establish%20Planner%20connection%20with%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505535%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F719524%22%20target%3D%22_blank%22%3E%40soorajmandhan%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EThere%20is%20a%20ready-made%20Power%20Automate%20template%2C%20you%20could%20use%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fgalleries%2Fpublic%2Ftemplates%2F1879528b45314f74bed7639405a8c1be%2Fexport-microsoft-planner-tasks-to-a-sql-database%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fgalleries%2Fpublic%2Ftemplates%2F1879528b45314f74bed7639405a8c1be%2Fexport-microsoft-planner-tasks-to-a-sql-database%2F%3C%2FA%3E%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3ETrutz%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506025%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20to%20establish%20Planner%20connection%20with%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506025%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2087%22%20target%3D%22_blank%22%3E%40Trutz%20Stephani%3C%2FA%3E%20!%20for%20your%20response.%20I%20really%20appreciate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514129%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20to%20establish%20Planner%20connection%20with%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514129%22%20slang%3D%22en-US%22%3EThe%20easiest%20way%20is%20to%20try%20the%20third%20party%20apps%20for%20this%20need%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518721%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20to%20establish%20Planner%20connection%20with%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518721%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1547%22%20target%3D%22_blank%22%3E%40Santhosh%20Balakrishnan%3C%2FA%3E%2C%3C%2FP%3E%3CP%3Ecan%20you%20elaborate%20more%20please%2C%20because%20still%20I%20am%20looking%20for%20to%20establish%20efficient%20connection%20with%20PowerBi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1534720%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20to%20establish%20Planner%20connection%20with%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534720%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F719524%22%20target%3D%22_blank%22%3E%40soorajmandhan%3C%2FA%3E%26nbsp%3BYou%20need%20to%20use%20third-party%20apps%20(such%20as%20Apps4Pro%20Planner)%20which%20connects%20Microsoft%20Planner%20to%20get%20the%20details%20about%20plans%20and%20tasks.%20It%20will%20create%20a%20dataset%20in%20the%20Power%20Bi%20with%20those%20details.%20You%20can%20utilize%20the%20dataset%20to%20create%20your%20dashboards.%20The%20app%20will%20sync%20the%20data%20with%20Power%20Bi%20at%20regular%20intervals.%20In%20this%20way%2C%20your%20dashboards%20will%20be%20live.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Community,

I'm required to design Power BI dashboard for Planner tasks but I am not able to connect the Planner data source with PowerBI. Therefore, I am keen to establish connection/data source with Planner in PowerBI to automate the Planner data i.e. tasks so on. Instead of exporting data all the time, my company want me to automate it by using of Power automate(trigger) or any other service. Can someone help me out.

It will be appreciated to share the knowledge.

 

Thank you!

6 Replies

Thank you @Trutz Stephani ! for your response. I really appreciate.

The easiest way is to try the third party apps for this need

Thanks @Santhosh Balakrishnan,

can you elaborate more please, because still I am looking for to establish efficient connection with PowerBi.

 

Thank you!

 

@soorajmandhan You need to use third-party apps (such as Apps4Pro Planner) which connects Microsoft Planner to get the details about plans and tasks. It will create a dataset in the Power Bi with those details. You can utilize the dataset to create your dashboards. The app will sync the data with Power Bi at regular intervals. In this way, your dashboards will be live. 

@soorajmandhan Were you able to set up a working solution? I'm wondering whether there are any approaches to avoid? Thank you!