Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Connect to Teams Data Source

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?

  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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.