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
Sorry I should have mentioned that they are private channels. Apparently private channels create their own site.
I've read somewhere that you can use Power Automate to get a list of sharepoint sites from all Teams channels. I can't think of ways other than that.
Yes I was hoping to not have to use Power Automate, but it looks like there is no other way, thank you for your help.