next year we are going to start using Microsoft Teams as our main tool for intra-company and intra-project communication and collaboration. We will especially make use of the Planner app as well as the new "Lists" app in order to track issues and tasks within a project. These are great features, however I see one major issue: Every planner app and every list creates a new, isolated entity in which it stores its data. I would rather like them to put all the data into one central data pool that I can then query with PowerBI in order to create a risk report for the entire project portfolio.
2 questions in this regard:
a) is it possible to connect PowerBI to the Planner App data? I couldn't find any connectors but I thought there might be workarounds like using Power Automate or Graph API (I am not experienced in those but would start digging deeper into those topics if you guys tell me that this is the way to go)
b) Is it possible to automatically incorporate that data into a powerBI dataset once a new Planner app is created?
Background info: We will create one team per project. Each one of the project phases will have a seperate channel (like design and engineering / calculation and budget / site management / ...) - The thing is, at any given time we have 50+ active projects. Each channel will have its own planner. So I will be looking at 200+ planner apps that need to be consolidated into one PowerBI dataset. There is no way to handle this manually. Any ideas?
Again, workarounds are welcome, even if this involves intermediate steps like pushing data from the individual Planners to a central sharepoint list or SQL server table using Power Automate.
thanks for any advice.