Tutorial: Embed a Power Apps visual in a Power BI report

APPLIES TO: ✔️ Power BI Desktop ✔️ Power BI service

In this tutorial, you use the Power Apps visual to create a new app that is embedded in a sample Power BI report. This app interacts with other visuals in that report.

If you don't have a Power Apps subscription, create a free account before you begin.

In this tutorial, you learn how to:

  • Add a Power Apps visual to a Power BI report
  • Work in Power Apps to create a new app that uses data from the Power BI report
  • View and interact with the Power Apps visual in the report

Prerequisites

Create a new app

When you add the Power Apps visual to your report, it launches Power Apps Studio with a live data connection between Power Apps and Power BI.

  1. Open the Opportunity Analysis sample report and select the Upcoming Opportunities page.

  2. Move and resize some of the report tiles to make space for the new visual.

    Move and resize report tiles.

  3. From the Visualizations pane, select the Power Apps icon, then resize the visual to fit the space you made.

    Visualization pane with Power Apps icon selected

  4. In the Fields pane, select Opportunity > Name, Product > Product Code, and SalesStage > Sales Stage.

    Screenshot showing the selection of the Name, Product Code, and Sales Stage fields.

  5. On the Power Apps visual, select the Power Apps environment where you want to create the app, then select Create new.

    Create a new app.

    In Power Apps Studio, you see that a basic app is created, with a gallery that shows one of the fields you selected in Power BI.

    Power Apps opens.

  6. Resize the gallery so it takes up only half of the screen.

  7. In the left pane, select Screen1, then set the screen's Fill property to "LightBlue" (so it shows up better in the report).

    Screenshot showing the color palette used to set the Fill property.

  8. Make some room for a label control.

    Change gallery dimensions.

  9. Expand the left navigation menu, choose + Insert, and select Text label from the list of controls.

    Label control.

  10. Drag the label to the bottom of your visual. Set the Text property to "Opportunity Count: " & CountRows(Gallery1.AllItems). It now shows the total number of opportunities in the data set.

    App with resized gallery.

    App with label updated.

  11. Save the app with the name "Opportunities App".

    Screenshot showing the screen for saving the app.

View the app in the report

The app is now available in the Power BI report, and it interacts with other visuals because it shares the same data source.

[App in Power BI report.

In the Power BI report, select Jan in the slicer, which filters the whole report, including the data in the app.

Screenshot showing the filtered report.

Notice that the opportunity count in the app matches the count in the upper left of the report. You can select other items in the report, and the data in the app updates.

Clean up resources

If you don't want to use the Opportunity Analysis Sample anymore, you can delete the dashboard, report, and dataset.

Considerations and limitations

For troubleshooting information, see Power Apps visual for Power BI

Next steps

Q&A visual
Tutorial: Embed a Power Apps visual in a Power BI report