Power BI and Power Apps connection – Power Apps used as visual in Power BI report

This guide describes how to use an application created in Power Apps as a visual in Power BI, with Power BI filters having impact on Power Apps app. This can also be used to write data into datasource from Power BI, using a Power App.

How to do it?

In Power BI

Connect Power BI to the data, create a visual, and publish it to powerbi.com. From there, continue working in powerbi.com, not in Desktop.

Insert the Power Apps visual. You can use an existing app, but it’s easier to select the “Create app” function.

In Power Apps

Now a new tab opens with the Power Apps editor and a draft of new app is created. Notice that a new “data source” called PowerBIIntegration appears in the app. You can use this as a source for a gallery, for example.

Once you finish editing, publish the app, and you can close the tab (you can ignore the “not saved” warning).

The app is embedded and interacts with Power BI. If it doesn’t, try refreshing the visuals and possibly also refreshing the data.