Forum Discussion
Grab data from Teams channel's posts
Yes, it is possible to connect Power BI to a Microsoft Teams channel and extract data such as the person who posted the news, the date and time of the post, and the text of the post.
To do this, you can use the Power BI content pack for Microsoft Teams. This content pack allows you to connect to a specific Teams channel and retrieve data such as messages, members, and activity.
Here is an overview of the process:
- In Power BI, go to the "Home" tab and select "Get Data" and then choose "Microsoft Teams".
- Enter your Microsoft Teams credentials.
- Select the channel from which you want to extract data.
- Use the "Transform data" button to customize the data, creating different queries and joining them with other data sources if needed
- Use that data to create a report or a dashboard.
Once you have the data, you can use it to create various visualizations that show the information you're interested in, such as a chart showing the number of messages posted by each person, or a table showing the text of recent posts.
Hello Anonymous , I know it's been a while since you posted this question.
Hopefully my answer could be a real help to you as well as to any one else who is
struggling doing this.
My solution is as following:
Use power automate to get all the posts details from teams channel, trigger it to run for every new post detected then load all of them into a SharePoint list and at this point you are able to plug power bi on this SharePoint list and use your data.
Please let me know if you need further assistance.
Have a walk thru on this?