cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

Connecting to Microsoft Teams using Power Bi

Hi folks,

 

Has anyone tried connecting up to Microsoft Teams using Power Bi to monitor message and phone call data. We currently monitor this with Skype for Business however with our recent integration of Teams is appears this is no longer possible unless we do a excel export.

 

Any ideas/tips would be greatly appreciated.

Thanks,

J

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Connecting to Microsoft Teams using Power Bi

@opticshrew,

You can connect to Office 365 Adoption Content Pack in Power BI Service. As stated in this article, usage data for Teams will be included in this content pack.

At the beginning of 2018, the content pack will be renamed to Usage Analytics and will reach general availability with an updated version that will include new metrics on teamwork and collaboration, usage data for Microsoft Teams, Yammer Groups and Office 365 Groups, and more.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Connecting to Microsoft Teams using Power Bi

Yes, 

 

I post a Power BI Idea 'Microsoft Teams as Data Source'.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35032543-microsoft-teams-as-data-...

 

what do you think?

Please vote when agree

View solution in original post

12 REPLIES 12
Highlighted
Microsoft
Microsoft

Re: Connecting to Microsoft Teams using Power Bi

@opticshrew,

Could you please describe more details that how you connect to Microsoft Teams from Power BI? What error message do you get currently?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver II
Resolver II

Re: Connecting to Microsoft Teams using Power Bi

Hi @v-yuezhe-msft

 

I'm not getting an error.

 

We track messages and phone calls through skype using the database in the back end.

 

Is there a way to do something similar with Teams, can we track phone calls and messages through some form of back end?

 

Thanks,

J

Highlighted
Microsoft
Microsoft

Re: Connecting to Microsoft Teams using Power Bi

@opticshrew,

I am not quite clear about your requirement? Do you want to track Teams data using Power BI?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver II
Resolver II

Re: Connecting to Microsoft Teams using Power Bi

HI @v-yuezhe-msft

 

Yes, sorry if I wans't clear.

 

I want to track Teams usage data for an organisation using Power Bi. This would include the number of phone calls and messages sent using Teams.

 

Thanks,

Jay

Highlighted
Microsoft
Microsoft

Re: Connecting to Microsoft Teams using Power Bi

@opticshrew,

You can connect to Office 365 Adoption Content Pack in Power BI Service. As stated in this article, usage data for Teams will be included in this content pack.

At the beginning of 2018, the content pack will be renamed to Usage Analytics and will reach general availability with an updated version that will include new metrics on teamwork and collaboration, usage data for Microsoft Teams, Yammer Groups and Office 365 Groups, and more.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Resolver II
Resolver II

Re: Connecting to Microsoft Teams using Power Bi

@v-yuezhe-msft

 

Would my account require any specific permissions?

 

Thanks,

Jay

Highlighted
Microsoft
Microsoft

Re: Connecting to Microsoft Teams using Power Bi

@opticshrew,

You have to be either a global administrator, Exchange administrator, Skype for Business administrator, or SharePoint administrator.

Reference:
https://support.office.com/en-ie/article/enable-the-power-bi-adoption-content-pack-for-office-365-9d...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Prodigy
Post Prodigy

Re: Connecting to Microsoft Teams using Power Bi

Yes, 

 

I post a Power BI Idea 'Microsoft Teams as Data Source'.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35032543-microsoft-teams-as-data-...

 

what do you think?

Please vote when agree

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Connecting to Microsoft Teams using Power Bi

Hi @opticshrew,  why the RLS is not working in teams. i have create pbix and it has all the RLS functioninng well at cloud workspace buit when i posted to Teams, seems RLS not supported there. any idea Pls?

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021