Forum Discussion
How to create a dashboard based on data from multiple Teams channels
Hi PowerAutomater ,
There is an existing Teams connector which is still in Beta but I doubt you'll find the information you need using it as it shows user activity only.
If your project plans were created using a Sharepoint list, I suggest you use the Sharepoint list connector instead. If you have multiple sites, maintain ist of those sites, connect to that list using Power BI (enter data, excel online, etc) and create a custom column to access the sharepoint sites using SharePoint.Tables function
This will create a column containing tables of available SharePoint lists from those SharePoint sites. You can expand the column and filter to the data you need
It will be a process of exploring which columns/tables have the data needed
Hi PowerAutomater ,
There is an existing Teams connector which is still in Beta but I doubt you'll find the information you need using it as it shows user activity only.
If your project plans were created using a Sharepoint list, I suggest you use the Sharepoint list connector instead. If you have multiple sites, maintain ist of those sites, connect to that list using Power BI (enter data, excel online, etc) and create a custom column to access the sharepoint sites using SharePoint.Tables function
This will create a column containing tables of available SharePoint lists from those SharePoint sites. You can expand the column and filter to the data you need
It will be a process of exploring which columns/tables have the data needed
The only issue is that multiple users can create channels in the Team and put new plans/lists in these as they need, so wouldn't I need to manually maitain the list of sites since each new channel creates a new site? I was hoping that maybe there was a way to get all of the lists dynamically be querying the actual Team and searching down it's hierarchy through all of the channels?
My tests shows that each channel in a Team points to the same SharePoint site assigned to that team. You can test it yourself.
