Edit

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

  • Article

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. Open the report in Editing mode by selecting Edit from the Options bar.

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

    Screenshot showing one option for making room on the report canvas.

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

    Screenshot of the Visualization pane with Power Apps icon selected.

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

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

    Screenshot of the Create new button.

    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.

    Screenshot showing what Power Apps looks like when it first opens.

  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. Select Gallery1 and make some room for a label control by changing Properties > Size > Height to 964.

    Note

    If you can't edit the Height field, try adjusting the size of the visual on the canvas first. Select the visual and drag one of the handles. Now edit the Height field.

    Screenshot showing how to change gallery dimensions.

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

    Screenshot of the Insert menu.

  10. Drag the label to the bottom of your visual. Set the Text property to "Opportunity Count: " & CountRows(Gallery1.AllItems). The visual on the canvas now shows a total of 487 opportunities in the dataset.

    Screenshot of Power Apps and the visual resized.

  11. Select the Save icon from the upper right corner. Save the app with the name "Opportunities 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.

Screenshot showing the Power Apps visual in the Power BI report.

In the Power BI report, select Jan in the slicer. This filters the whole report, including the data in the Power Apps visual.

Screenshot showing the filtered report.

Notice that the updated opportunity count in the Power App visual 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 save the Opportunity Analysis sample with the Power Apps visual, delete the dashboard, report, and semantic model.

Considerations and limitations

For troubleshooting information, see Power Apps visual for Power BI.

Related content