Blog

Embed PowerApps in PowerBI-Part 3

dynamics 365 customer engagement

In this series, so far, we have embedded a Power BI report/tile in canvas app and then in model driven apps. Now we will do the reverse, where we will embed PowerApps in Power BI. When there is more focus on action based on analytics, it makes more sense to embed a business app in PowerBI.

Microsoft has made it so much easier to do this task now since its inception. Earlier, we had to add web content, generate embeddable uri etc. etc. But now, we have a certified PowerApps custom visual in Marketplace which we can import and use it in any of our Power BI reports and dashboards. How cool is that!

powerapps in power bi

Let us go through the steps of creating a simple PowerApps integrated Power BI report.

1)      On PowerBI.com, go to the workspace and click on the edit report where you want to add the app

powerapps in power bi

2)      On the Visualizations pane, click on PowerApps custom visual, it gets added to the report you were on just like any other visual.

powerapps in power bi

3)      Next, set all the fields that you need for the app to function. In my sample, I am using the Dashboard in a day report and I am trying to send an email to each country sales group when I see the sales revenue going down. I am selecting the fields I want to display and also the fields I want to update. In this case, I am updating comments and sending emails using the other fields.

powerapps in power bi

4)      Next important step is to make sure you are choosing the right environment for the PowerApps app, whether you are using an existing app or creating a new app.

powerapps in power bi

5)      In my case I chose an existing app, it brings up the PowerApps designer as below. Notice that it added PowerBIIntegration object right under App, this is key for this to work

powerapps in power bi

6)      Now you have to start linking each of your controls to the appropriate fields you have pulled from PowerBI. For selecting the field values, use First(PowerBIIntegraion.Data).FieldName. You can also have another data source in your app that you can join with PowerBIIntegration.Data object if needed.

powerapps in power bi

7)      Now save the app and publish as usual in PowerApps and close the window.

powerapps in power bi

8)      Back in the PowerBI report, notice that the PowerApps control will refresh and bring up the latest updates.

9)      Now pull the report, started clicking on the linked visual, you will notice that the data in PowerApps custom control will also start appropriately changing.

powerapps in power bi

10)      In my case above, the head of the organization sees the sales is declining in a couple countries steadily and quick adds his comments and sends out an email to the sales group for a quick meet and actions!!

Just like any brand new control that is integrating multiple tools, there are a few limitations with this custom control that you can read up here.  A few observations during the creation of this sample

  • There were times when I ran into issues with the report locking up on me, but soon got resolved by itself and sometimes I had to close the session.
  • Sometimes, it looked like the PowerBIIntegration object was not working, but after closing and editing it back from PowerBI seems to resolve the issue
  • Another note, if you create an app from PowerBI, it seems like it always add in phone mode, so if you are looking for tablet mode app, I suggest you create one beforehand and then add it through PowerBI
  • But all in all, it is definitely very promising control.

Related Posts


vnb-blog-emergency-response-powerapps

May 18, 2020

Hospital Emergency Response Solution: Unboxing the Microsoft Power Platform Template App

A situation like COVID-19 where the hospitals are challenged to manage supplies and make decisions as they meet an increase in number of patients, Microsoft Power Platform template for Emergency Response Solution became a very efficient help. VNB Power Platform team has been an early adopter of this solution and have implemented it for many

vnb-blog-free-powerapps

May 18, 2020

Get 6 free months of select Microsoft Power Platform solutions to support COVID-19 responses

Microsoft is offering free subscription to its Power Platform for 6 months. Respond quickly to changing organizational needs due to COVID-19 by quickly building business apps using PowerApps, Power Automate and CDS. Available to healthcare, governments, nonprofits, and educators free of charge for six months.* Power Apps Quickly build and share custom, low-code applications. Includes: