Forum Discussion
JOSE ANGEL HINOJOSA
Jan 10, 2018Copper Contributor
How to automate Planner and integrate it with Power Bi
Lets say on my work i have to do the same exact activities, one after another and my boss wants to assign those tasks to my team through Microsoft Teams, how can i make like a sample tasks that i jus...
Dean_Hall
Sep 10, 2018Copper Contributor
You can achieve this using Flow. Use Flow to push the data from Planner into SharePoint lists (one for plans, one for boards and another for tasks) - then report in Power BI on those lists.
This works fine for me - and I have a scheduled timer trigger updating every 30 mins so the reports are up to date at all times. Just remember to pull in 3 lists and reference them in your model and it works fine.
Hope this helps.