Is there any way to build Power Bi report on Teams channel.

Hi, I am Glenn, Independent Advisor here to work with you on this issue.

To build the Power BI report you have described, you will need to connect Power BI to your Microsoft Teams data, which can be done using the Power BI Content Pack for Microsoft Teams.

Once connected, you can use Power BI's data visualization tools to create charts and graphs that show the number of posts, how they were addressed, and the status of those posts (closed/pending) on a weekly or monthly basis. Additionally, you can set up automatic data refresh to ensure that the report updates automatically, rather than having to manually update it.

To get started, follow these steps:

Connect Power BI to Microsoft Teams data: Go to the "Get Data" option in Power BI Desktop and select "Microsoft Teams". You will need to sign in with your Microsoft account to connect to your Microsoft Teams data.

Create the report: After connecting to the data, use Power BI's drag-and-drop interface to create charts and graphs that show the information you want to see in your report. You can use filters to focus on specific channels or time periods.

Set up automatic data refresh: Go to the "Data Source Settings" option in Power BI Desktop and enable automatic data refresh. This will ensure that your report updates with the latest data from Microsoft Teams on a schedule that you specify.

Share the report: When you are satisfied with the report, you can publish it to the Power BI service and share it with others in your organization.

Note: To perform these steps, you will need a Power BI Pro or Power BI Premium license.

Hi, and thanks for reaching out. My name is Saeid. I'll be happy to help you out today.You can try the following steps to resolve the issue:

Yes, it is possible to build a Power BI report in Teams channel. You can connect Power BI to the Microsoft Teams channel by embedding a Power BI report in a Teams tab. To do this, you can follow these steps:

Create a Power BI report in the Power BI Service and make sure the data is updated regularly.

In the Power BI Service, click on "File" and then "Publish to Web." This will create a shareable link for the report.

In Microsoft Teams, go to the channel where you want to embed the report and click on the "Add a tab" button.

Select "Power BI" from the list of available tabs.

Enter a name for the tab and paste the shareable link from Power BI in the "Report URL" field.

Click on "Save" and the report will now be embedded in the Teams channel and will be automatically updated as data changes.

This way, you can keep track of the number of posts in each channel, how they are addressed, and the number of posts that are closed or pending.

I have tried to connect as per the above suggestions but could see only Team name. But I want to see channel names which are associated with that team and want to breakdown the total no of posts, responds and reactions in channel wise.

Do I need to have admin rights for the teams channel which was created in Teams.?

By doing so can we get the details of users who responded to posts, and how many posts are handled by my team. because the posts are addressed by another team as well. But want to differentiate which team has done what.

like which team handled how many posts.