Microsoft Business Application Summit Power Platform Workshop

 

Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application.

Step 1.  Create an app workspace to host the application. 

To do this: Log in to PowerBI.com and click on Workspaces > New Workspace.

For people doing this at Microsoft Business Applications Summit we have created accounts for you to use with the names MBASUser201@Powermvps.com through MBASUser400@Powermvps.com (Yes we have 200 people signed up!!) …I will give out the Pass word at the event.  As I used the name MBAS please name yours MBAS### with the number being your assigned account.

SCOREBOARD1

Step 2.  Navigate to the Workspace content view

SCOREBOARD2

Step 3.  Create a streaming dataset

Click on create and select streaming Dataset

SCOREBOARD3

Step 4.  Set the streaming dataset to be API based.

Click on API and select Next

SCOREBOARD4

Step 5.  Set the streaming dataset properties

Add the fields:

Score > as number

Person > as Text

Contest > as Text

Date > as DataTime

SCOREBOARD5

Step 6.  Create a report displaying the streaming dataset

Select Datasets and then select that chart glyph for the dataset you just created in the above step

SCOREBOARD6

Step 7.  Add a visual to display the score by Person

Drag the Score field to the Power BI report design canvas.  This should default to a clustered Column chart, if not change it one and add the person as the axis.

SCOREBOARD7

Step 8.  Pin the Column Chart to a Scoreboard dashboard.

Click the push pin glyph in the visual you just created and save the report with the name “Scoreboard”

SCOREBOARD8

Step 9.  Create a new Dashboard

Select New dashboard and give the dashboard name “Scoreboard” and click pin.

The reason for using a dashboard rather than a report is the fact that reports are not real time yet. (written 6/3/2019).   Do NOT navigate to the dashboard yet. 

Scoreboard9

Step 10.  Adding a PowerApps to the Power BI Report (using the PowerApps custom visual)

In the Power BI visuals section click the ellipsis select the “Import from marketplace”, search for PowerApps and select the visual “PowerApps (Preview)”.

SCOREBOARD11

Step 11.  Creating the PowerApps application with the Power BI custom visual.

Drag the fields Contest, Person and Score to the PowerApps custom visual.

SCOREBOARD12

Step 12.  Add a Rating control to the PowerApps application

SCOREBOARD14

Step 13.  Add a Button control to the PowerApps application

SCOREBOARD15

Step 14.  Add a Text Input control to the PowerApps application

SCOREBOARD16

Step 15.  Add a Label control to the PowerApps application

SCOREBOARD17

Step 16.  Creating a new Flow and attaching it to the PowerApps button

SCOREBOARD18

Step 17.  Add the Power BI Action to the Flow

SCOREBOARD19

Step 17.  Add the Power BI action to the Flow.

Set the workspace to the workspace you created in step one i.e. MBAS####.

Set the dataset to “Scoreboard” that you created in step #5.

The table will be called “Real Time Data” (this set automatically)

SCOREBOARD20

Step 18.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.

SCOREBOARD21

Step 19.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD22

Step 20.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD23

Step 21.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD24

Step 22.  Save your Flow

Now save your Flow.  While not done in this screen shot it is recommended that you name your Flow by default called “from PowerApps” before saving.

SCOREBOARD25

Step 23.  Connect your button to the Flow

Navigate back to the PowerApps tab and select the Flow you have saved in the step above.  This will add a parameter to the Flow call for every field in the streaming dataset.

SCOREBOARD26

Step 24.  Supply the Flow parameters

Set the score flow parameter for score to value property of the Rating1 control.  Set the person parameter to the TextInput1.Text control property.  Set the contest parameter to the harded coded string “MBAS”.  Set the Date parameter to “Now()”.

SCOREBOARD27

Step 25.  Save the PowerApps application

Under the file menu select “Save”

SCOREBOARD28

Step 26.  Save the PowerApps application (cont)

Name your application and select the “Save” button in the lower right hand corner.

SCOREBOARD29

Step 27.  Pin the PowerApps application to the dashboard to the Power BI Dashboard.

Navigate to the Power BI Tab.  You will notice the application is already visible in the Power BI.  In the upper right hand corner of the Power BI visual select “Pin visual”.

Select the “Scoreboard” dashboard created above.

SCOREBOARD30

Step 28.  Test the PowerApps/Power BI integration .

In the Power BI Dashboard type a persons name and select a score.  Hitting the button should update the column chart created above.

finished

Congratulations you have created a streaming dataset, a PowerApps application and a real time dashboard!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s