Power Automate/PowerBI and Planner

%3CLINGO-SUB%20id%3D%22lingo-sub-2259243%22%20slang%3D%22en-US%22%3EPower%20Automate%2FPowerBI%20and%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259243%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20most%20powerful%20thing%20I%20can%20do%20with%26nbsp%3B%20Planner%20is%20aggregate%20its%20data%20with%20PowerBI.%20The%20ability%20to%20visualize%2C%20consume%2C%20understand%2C%20and%20map%20out%20programmatic%20process%20is%20truly%20invaluable.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETwo%20questions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EIs%20the%20limit%20to%20retrieve%20400%20tasks%20in%20the%20Power%20Automate%20Planner%20Connector%20still%20a%20limitation%3F%3CUL%3E%3CLI%3EHow%20are%20these%20retrieve%20lets%20say%20if%20we%20have%20600%2C%20and%20ordered%20how%3F%26nbsp%3B%3C%2FLI%3E%3CLI%3EHow%20can%20we%20get%20those%20numbered%20from%20401-600%3F%20Let's%20say%20if%20we%20are%20dumping%20this%20data%20into%20a%20database%20or%20excel%20file%20for%20PowerBI%20consumption.%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EIs%26nbsp%3B%20there%20going%20to%20be%20a%20direct%20connection%20to%20PowerBI%20via%20Planner%20as%20a%20%22data%26nbsp%3B%20source%22%3F%20I%20know%20there%20are%20commercial%20stuff%20out%20there%2C%20but%20in%20some%20environments%2C%20we%20can't%20get%20commercial%20software.%20This%20is%20why%20the%20excel%20file%20as%20the%20solution%20for%20the%20holding%20data.%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
New Contributor

The most powerful thing I can do with  Planner is aggregate its data with PowerBI. The ability to visualize, consume, understand, and map out programmatic process is truly invaluable. 

 

Two questions:

 

  1. Is the limit to retrieve 400 tasks in the Power Automate Planner Connector still a limitation?
    • How are these retrieve lets say if we have 600, and ordered how? 
    • How can we get those numbered from 401-600? Let's say if we are dumping this data into a database or excel file for PowerBI consumption. 
  2. Is  there going to be a direct connection to PowerBI via Planner as a "data  source"? I know there are commercial stuff out there, but in some environments, we can't get commercial software. This is why the excel file as the solution for the holding data. 
0 Replies