Edit

How to create a canvas app with Power BI visual

  • Article

Microsoft Power BI is a powerful analysis and visualization tool. Power Apps is great at enabling people to take action on the web and mobile. Canvas apps created using Power Apps can be embedded in a Power BI report. Similarly, a Power BI report tile can be added to a canvas app. The best of both worlds can be achieved at the same place and same time.

In this example, we'll create a quick Power BI report and a canvas app, and then see how we can add the report as a tile in the app.

Watch this video to learn how to create a canvas app with Power BI visual:

Prerequisites

To complete this lesson, we'd need the ability to create Power BI dashboards and reports.

Sign in to Power BI

Sign in to Power BI with the same Office license as the one used for creating the Power Apps.

Create a new workspace

  1. Select Workspaces from the left-pane.

    Select the Workspaces link

  2. Select Create a workspace.

    Select the Create a workspace button

  3. Enter a name for the workspace, and then select Save.

    Enter a name for the workspace

    The workspace gets created

    The workspace gets created

  4. Select + New, and add a dashboard.

    Select the New button and add a Dashboard

  5. Add a name for the dashboard, then select Create.

    Add a name for the dashboard

    The Power BI dashboard gets created within the workspace we created

    The Power BI Dashboard gets created

  6. Open the workspace, select + New, and then select Dataset to create a new dataset.

    Open the workspace and select the New button

  7. Select Samples under "More ways to create your own content" to use sample data.

    Select the Samples hyperlink

  8. Select Sales and Marketing sample. You can also select another sample of your choice.

    Select the Sales and Marketing sample

  9. Select Connect to connect to the sample data.

    Select the Connect button to connect to the data sample

    A dataset with the Sales and Marketing sample and a report gets added to the Workspace.

    Sample and a report gets added to the workspace

  10. From the left-pane, select the report that was created from the dataset, select ... (ellipsis), and select then select Pin to a dashboard.

    Select the Pin to dashboard option

  11. Select Existing dashboard, select the dashboard, and then select Pin live.

    Select the dashboard and select Pin live

The report gets added to the dashboard, and is ready for use in Power Apps.

Create a new canvas app

  1. Start by creating a blank canvas app.

  2. Select Insert > Charts > Power BI tile.

    Select Inser Charts and select Power BI Tile

    The Power BI Tile gets added to the screen.

    The Power BI Tile gets added to the screen

  3. Select the Workspace, dashboard and tile created earlier to add the Power BI tile to the canvas app.

    Power BI Tile is added to the canvas app

  4. Save and publish the app.

You've created a canvas app with Power BI tile.

See also