cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nickyvv
Super User I
Super User I

Better Together: Part 1 - Use The Power Platform to Create a Scoring App with a Live Dashboard

I think many of you are familiar with the Power Platform, but let's go over it quickly.

The Microsoft Power Platform now consists of 4 products:

  • Power BI: Make informed, confident business decisions by putting data-driven insights into everyone’s hands.
  • Power Apps: Turn ideas into organizational solutions by enabling everyone to build custom apps that solve business challenges.
  • Power Automate: Boost business productivity to get more done by giving everyone the ability to automate organizational processes.
  • Power Virtual Agents: Easily build chatbots to engage conversationally with your customers and employees—no coding required.

0 Power Platform.png

In a previous blog post on getting some interactivity in your presentation, I already talked about the integration of Microsoft Forms, Power Automate and Power BI, you can read about that here:

In this new 2-part series I would like to show an example of how Power Apps, Power Automate and Power BI can work better together!

 

Introduction

Let's start with the final goal in mind. Let's say for example, I want to have an interactive quiz during a presentation or workshop. An attendee will answer a question and be awarded points for the (partially) correct answer. I want to have a form/an app where I can enter the name of the attendee and the score after having received an answer.

Ideally I also want to show the results on the same screen so I don't have to switch between entering a score and showing the result.

 

As you might have guessed, I will accomplish this by using 3 of the Power Platform products:

  • I create a Power App, with 2 textboxes and a button to save the data
  • With a press of the button, a flow (Power Automate) will kick off to send this data to a Power BI streaming dataset
  • This dataset will then immediately (and automatically, so without user interaction) be refreshed and shown in a dashboard in Power BI, where the Power App is also embedded as a visual

So the good thing is: there's no switching between screens, or refreshing a page involved.

 

The Power BI dashboard will look something like this:

1 final dashboard.gif

 

With this goal in mind, let's have a look in detail at how we can achieve this!

 

Create a Power BI streaming dataset

The streaming dataset, of type push, has to be created before selecting the workspace in Power Automate, because otherwise the streaming dataset won't show up. In PowerBI.com you can create a dataset in any workspace, also in My Workspace. You do that by clicking on the +-sign in the home screen of your workspace.

 

 

Make sure you turn on the switch for Historic data analysis when creating the dataset. That way Power BI will store the data that's sent through this data stream, and you'll be able to do reporting and analysis on the collected data stream. This switch can also be used to clear the dataset.

The Date field is optional, but it could come in handy later, when I want to filter out my test values in the report for example.

 

 

Create an instant Power Automate flow

Because we create a Power App with a button to save the data, and thus to manually trigger the flow, we need to create an instant flow over in Power Automate.

 

 

In Part 2 I will explain how to create the Power App, with a button to save the data to the streaming dataset. Last, I will also link the App to the Power BI Report and embed it in a Dashboard. 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


0 REPLIES 0

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors