Power BI

Content by Charles Sterling

Walk through of using the PowerApps custom visual in Power BI

This blog post will walk through how to get started with this new exciting custom visual for Power BI with real time datasets using the application from the App in a Day training.

I have also created a very short video for the beginning steps which can be found here:

https://aka.ms/powerappscustomvisualvideo

Walk through Steps:

1. Add the PowerApps Visual Custom Visual to a report.

While I am referencing a local file you will likely find it easier to use the integrated store experience.

image

2.  Add the custom Visual to the report design surface.

As part of this add the fields you want to interact with in PowerApps.  Note: this is required to get the options to either select an existing PowerApps application or create a new one.

image

3.  Specify whether you want an existing app or new.

I would suggest you start with new apps as you automatically get the PowerBIIntegration object created for you.

image

4.  Adjust the layout of the default gallery

In this case i wanted to reference the logo image which is stored in the “Logo” field so am using the image and title layout…and will delete the title.

image

5. Set the source for the image in Gallery1.

You set the data source of the image by selecting top most image displayed in the gallery.  I have also deleted the title and resized this gallery to be very small on the bottom of the PowerApps form.

image

6. Add the second gallery, add its data source and set its properties

These steps are outlined in the App in a Day training.

image

7.   Add the button

These steps are outlined in the App in a Day training.

image

8.  Associate the PowerApps button up to a Flow that sends the computer order to the correct back ends

…In my demo the Flow was updating a real time Power BI Dataset, an Email Approval and a SharePoint List.

Directions for creating a Real time streaming Dataset can be found here: https://blogs.msdn.microsoft.com/charles_sterling/2017/06/08/power-bi-streaming-datasets-hands-on-lab/

image

9. Create the Flow to update the Real Time Streaming Dataset

This was as simple as adding the Power BI Add Rows to Dataset activity, following the prompts and selecting “Ask in Power Apps” for all the fields.

image

10. Save the PowerApps application and viola…your app is now in Power BI!!!!!

Here is a screenshot of the finished report

image

Note: when i click on the tree to select the manufacture the PowerApps ONLY shows me devices from that manufacture!

Here is a screenshot of the finished dashboard with cards updating in real time when computer orders are placed!

image