Embed a new canvas app in a Power BI Report

Power BI enables you to extend its capabilities by adding custom visuals to a report. In this tutorial, you use the Power Apps custom visual to create a canvas app that's embedded in a sample report. This app interacts with other items 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:

  • Import the Power Apps custom visual into a Power BI report
  • Create a new app that uses data from the report
  • View the app in the report

Prerequisites

Import the Power Apps custom visual

The first step is to import the Power Apps custom visual so that you can use it in the sample report.

  1. In the Opportunity Analysis Sample report, click or tap the Upcoming Opportunities tab.

  2. At the top of the report, click or tap Edit report.

  3. In the Visualizations pane, click or tap the ellipses (. . .) > Import from marketplace.

    Import from marketplace

  4. In the Power BI Visuals screen, search for "PowerApps", then click or tap Add. Power BI adds the custom visual icon to the bottom of the Visualizations pane.

    Power Apps visual icon

  5. Save the report.

Create a new app

Now you add the custom visual to your report and create a new app based on data in the report. When you create the app, it launches Power Apps Studio with a live data connection between Power Apps and Power BI.

  1. Move and resize some of the report tiles to make space for an app.

    Move and resize report tiles

  2. Click or tap the Power Apps custom visual icon, then resize the tile to fit the space you made.

  3. In the Fields pane, select Name, Product Code, and Sales Stage.

    Select fields

  4. In the custom visual tile, select the Power Apps environment where you want to create the app, then click or tap 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.

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

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

    App with resized gallery

  7. Add a Label control under the gallery, with the Text property set to "Opportunity Count: " & CountRows(Gallery1.AllItems). It now shows the total number of opportunities in the data set.

    Opportunity count

  8. Save the app with the name "Opportunities".

View the app in the report

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

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.

Next steps

In this tutorial, you learned how to:

  • Import the Power Apps custom visual into a Power BI report
  • Create a new app that uses data from the report
  • View the app in the report

Advance to the next article to learn more