Connect to Teams Data Source

[Anonymous]

Is there a way I can create a dashbaord in the Power Bi Service (not desktop) and connect to a data source in MS Teams?

[collinq]

Hi @Anonymous ,

If you are talking about Teams utilization, you can use the CQD data (call quality dashboard).   (https://docs.microsoft.com/en-us/microsoftteams/cqd-teams-utilization-report)   

If you are using a file from Teams you will need to use the link from Teams to the file location (SharePoint for the Team).

Since you said that you are using the service you can do this by getting the data for a file and then SharePoint- Team Sites.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Anonymous · Accepted solution]

I was able to figure it out. So, if the data source is posted in MS Teams as an excel file, etc, click the Sharepoint link in MS Teams where the source resides. In the Power BI Service, select Get Data, Files, the select SharePoint - Team Sites. When the box opens, paste in the Sharepoint link from MS Teams and you should then see your documents that are posted in MS Teams. You can then select one and import as data source.