Integrate Power BI Inside of Power Apps [Building Power Apps In Microsoft Teams – Ep. 11]

In episode 11 of the Building Power Apps in Microsoft Teams series, Matt Peterson from Pragmatic Works demonstrates how to integrate Power BI directly into Microsoft Teams applications. This integration allows users to bring insights from Power BI reports into their Power Apps, enabling better decision-making with real-time, interactive dashboards and visuals.

Why Integrate Power BI with Teams Apps?

By embedding Power BI into a Teams-based Power App, organizations can leverage the data they collect inside Dataverse and immediately visualize it through dashboards. This provides an interactive way for end users to explore data without leaving the Teams environment.

Initial Setup

Matt begins by showing the student check-in app he has been building throughout the series. Prior to recording, he created a Power BI report from the Dataverse tables linked to the app. He then published that report to the Power BI service and pinned either full report pages or individual tiles to dashboards.

Those dashboards are then embedded into Power Apps screens inside Microsoft Teams, so that users can filter, drill down, and analyze the collected student data seamlessly.

Embedding Reports and Tiles

To add a Power BI element in Power Apps:

1. Create a new screen in your Teams Power App.
2. Use the Insert ribbon and search for Power BI tile.
3. Select the appropriate workspace where the Power BI report has been published.
4. Choose either a live report page or a single visualization tile from a dashboard.

Live report pages allow users to interact with visuals directly inside the app. Individual tiles, on the other hand, act as shortcuts—when clicked, they open the full report in Power BI.

Sharing Considerations

One key point Matt emphasizes is sharing permissions. Embedding a Power BI report into a Teams app does not automatically give users access to the underlying report. For users to see the data:

• The Power BI report must be shared with them, or they must be part of the workspace where it resides.
• The Power App itself must be shared with those users.

Building the Power BI Report

While Matt does not walk through full report creation, he explains the necessary steps:

1. Use Power BI Desktop to connect to Dataverse data from the Teams app.
2. Click Publish to push the report to a workspace in the Power BI service.
3. From there, pin visuals or pages to dashboards for embedding into Power Apps.

Exporting Data from Dataverse

Data used in the app, such as student check-ins, can be exported to Power BI through Dataverse. By choosing Analyze in Power BI inside Teams, a connection file is downloaded. Opening it in Power BI Desktop reveals the Dataverse tables with their relationships already defined.

Cleaning and Transforming Data

Matt highlights best practices when preparing data for reporting:

• Rename tables for clarity (e.g., “Student Table” or “Check-in Table”).
• Use Choose Columns to remove unnecessary standard columns and keep only those created for the app.
• Eliminate duplicate or redundant data created by lookups or relationships.

Because Dataverse is relational, Power BI automatically establishes one-to-many relationships, such as between students and their check-ins or rooms and multiple check-ins.

Adding a Date Table

For time-based analysis, Matt incorporates a date table. This enables filtering by year, month, or day instead of just individual timestamps. Pragmatic Works provides a Power Query script, shared by Devin Knight, to easily generate this table within Power BI.

Key Benefits

• Centralized insights: View Power BI dashboards without leaving Teams.
• Interactivity: Drill into live reports or click tiles to expand into full reports.
• Data accuracy: Live Dataverse connections ensure up-to-date results without scheduled refreshes.
• Scalability: Supports multiple users as long as both the app and reports are shared properly.

Conclusion

In this episode, Matt Peterson showcases how simple it is to bring analytics into Microsoft Teams by embedding Power BI dashboards inside Power Apps. From publishing reports to cleaning data in Dataverse, the process connects raw information with actionable insights. By following these steps, organizations can empower users to interact with data directly where they work, boosting collaboration and decision-making within Teams.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power Apps and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.