Power Apps custom visual for Power BI
Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps custom visual, you can pass context-aware data to a canvas app, which updates in real time as you make changes to your report. Now, your app users can derive business insights and take actions from right within their Power BI reports and dashboards.
Using the Power Apps custom visual
Let's look at the steps required to use the Power Apps custom visual in your Power BI report.
Power Apps custom visual is available by default in the Power BI service. If you are using Power BI Desktop and don’t see it, you must upgrade to the latest version of Power BI Desktop.
Add the Power Apps visual to your report, and set the data fields associated with it.
You can choose an existing app or create one, but the report must be published to the Power BI service and opened in Microsoft Edge or Google Chrome.
If you choose to create an app, you can choose in which environment to create it.
If you choose to use an existing app, the visual prompts you to open the app in Power Apps. The visual then sets up the required components in your app so that Power BI can send data to Power Apps.
If you create a new app, Power Apps creates a simple app with the required components already set up.
You must create a new app from Power Apps custom visual in Power BI report for the
PowerBIIntegration.Refresh()function to be available in the app.
Now in Power Apps Studio, you can use the data fields you set in step 2. The
PowerBIIntegrationobject acts like any other Power Apps read-only data source or collection. You can use the object to populate any control, or join and filter with other data sources.
This formula joins Power BI data with the Customer data source:
The Power BI report and the instance of Power Apps Studio that was launched share a live data connection. While they are both open, you can filter or change the data in your report to see the updated data reflect immediately in your app in Power Apps Studio.
After you have completed building or making changes to your app, save and publish the app in Power Apps to see your app in the Power BI report.
Once you are satisfied with your changes, make sure to share the Power Apps app with users of your report and then save your report.
And with that, you have created a report in which your users can take actions as they gain insights from your data.
If you need to makes changes to an app, open the report in edit mode, click or tap More options (. . .) on the Power Apps visual and select Edit.
Limitations of the Power Apps custom visual
The following limitations apply to the Power Apps custom visual:
- If you change the data fields associated with the visual, you must edit the app from within the Power BI service by selecting the ellipsis (...) and then selecting Edit. Otherwise, the changes won't be propagated to Power Apps, and the app will behave in unexpected ways.
- The Power Apps custom visual can't trigger a refresh of Power BI reports and Power BI data sources from within Power BI Desktop. If you write back data from the app to the same data source as the report, your changes won't be reflected immediately in Power BI Desktop. Changes are reflected on the next scheduled refresh.
- The Power Apps custom visual can't filter the data or send any data back to the report.
- You'll need to share the Power Apps app separately from your report. Learn about sharing apps in Power Apps.
- Power BI Report Server does not support the Power Apps custom visual.
- Following limitations apply when using the
- You must create a new app from Power Apps custom visual in Power BI report for this function to be available in the app.
- You must use a source that supports DirectQuery and the data connection must be created using DirectQuery method.
- Power Apps in Power BI Desktop provides data to Power Apps Studio when creating apps but not while editing. Use Power BI Web to preview the data while editing apps.
We recommend that you first publish your report to the Power BI service and then create or modify apps.
The following table lists the browser supportability for view, create and modify actions of the Power Apps custom visual. Supported browsers and actions are identified by a check mark ( ✓ ).
|Internet Explorer 11||✓|
|All other browsers|
* In Safari, you must enable cross site tracking (Preferences > Privacy, and clear Prevent cross site tracking) to view Power Apps custom visual.
To navigate the Power Apps visual using the keyboard follow these steps:
- Focus selection on the Power BI Report for the desired Power Apps visual.
- Use the Tab key on the keyboard until the visual is highlighted.
- Use the Ctrl+Right key on the keyboard to enter the visual.
- Use the Tab key on the keyboard until the desired component of the visual is selected.
For more information see: Power BI Accessibility Documentation