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

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 Name, Product Code, and Sales Stage.

    select fields

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

    Create 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).

    color palette

  8. Make some room for a label control.

    change gallery dimensions

  9. Under gallery, insert a text label control.

    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".

    save 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.

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.

Limitations and considerations

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