cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
opticshrew Member
Member

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
Moderator v-yuezhe-msft
Moderator

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

yoshihirok Member
Member

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

10 REPLIES 10
Moderator v-yuezhe-msft
Moderator

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.
opticshrew Member
Member

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

Moderator v-yuezhe-msft
Moderator

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.
opticshrew Member
Member

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

Moderator v-yuezhe-msft
Moderator

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

opticshrew Member
Member

Re: Connecting to Microsoft Teams using Power Bi

@v-yuezhe-msft

 

Would my account require any specific permissions?

 

Thanks,

Jay

Moderator v-yuezhe-msft
Moderator

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.
yoshihirok Member
Member

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

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 149 members 1,875 guests
Please welcome our newest community members: