Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application. A video of these steps can be seen at:
https://www.youtube.com/mspowerplatform
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.comthrough MBASUser400@Powermvps.com (Yes we have 200 people signed up!!) …I will give out the Password at the event.
As I used the name MBAS please name yours MBAS### with the number being your assigned account.
Click on create and select streaming Dataset
Click on API and select Next
Add the fields:
Score > as number
Person > as Text
Contest > as Text
Date > as DataTime
Select Datasets and then select that chart glyph for the dataset you just created in the above step
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.
Click the push pin glyph in the visual you just created and save the report with the name “Scoreboard”
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.
In the Power BI visuals section click the ellipsis select the “Import from marketplace”, search for PowerApps and select the visual “PowerApps (Preview)”.
Drag the fields Contest, Person and Score to the PowerApps custom visual.
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)
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.
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”
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”
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”
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.
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.
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()”.
Under the file menu select “Save”
Name your application and select the “Save” button in the lower right hand corner.
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.
In the Power BI Dashboard type a persons name and select a score. Hitting the button should update the column chart created above.
Congratulations you have created a streaming dataset, a PowerApps application and a real time dashboard!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.