Integrating PowerApps, Power BI and Flow to Create Realtime Streaming Applications

Author image By Manish Patel  |  Friday, August 28, 2020 01:44 PM  |  3 min read  |   1177

Power BI real time streaming

Data is the lifeblood of modern business and now we’re generating more than ever. But the collection of piles of digital information isn’t of much use unless the organization is able to process it in a sensible way. And, that’s where a business intelligence software comes to the rescue. Power BI pulls the data together and processes it to intelligent insights using visually compelling and easy-to-process graphs, charts, and documents. This allows users to generate and share clear and useful insights into what’s happening in the business. Just think about how implementing a platform can help you such useful information to help you make actionable decisions? In this post, we’re going to discuss how integrating PowerApps, Power BI and Flow will help you to create real-time streaming applications. So, let’s get started.

Here, we will demonstrate how integrating PowerApps, Power BI and flow will help you to create a streamline application by creating a scoreboard application.

Step 1: Let’s create an app workspace to host the application

Log in to PowerBI.com and then move towards Workspaces -> New Workspace.

Step 2: Navigate to the workspace content view

Step 3: Let’s create a streaming dataset

To create a streaming dataset, click -> create and then select -> streaming dataset

Step 4: Let’s set the streaming dataset to be API based

Now click on API and then select Next

Step 5: Set streaming dataset properties

In order to set the streaming dataset properties, you need to configure the below variables;

  • Add the fields:
  • Score as NUMBER
  • Personas TEXT form
  • Contest as TEXT form
  • Date as DATA TIME format.

Step 6: Creating a report to display streaming dataset

In order to generate a dataset report, select the dataset. Then select the chart glyph for the dataset that was just created in step 5.

Step 7: Add a visual to display the score by a person

In order to display a person score in visual, drag the scoreboard to the design canvas. The default value should be the clustered column chart and once the value is set, add the person as the axis.

Step 8: Pin the column chart to the scoreboard dashboard

In order to pin the column chart, click the pushpin glyph from the visual and save the report with the name “Scoreboard”.

Step 9: Create a new dashboard

To create a new dashboard, select -> New dashboard and name it as “Scoreboard” and click pin.

Step 10: Adding PowerApps to the PowerBI report

In the Power BI visuals, click the ellipsis and select -> Import from the marketplace. Now search for PowerApps and select -> PowerApps Preview

Step 11: Creating Powerapps app with PowerBI Custom Visual

Now drag the fields names contest, person and score to the PowerApps custom visual

Step 12: Add Rating Control to the PowerApps application

Step 13: Now add a button control to the PowerApps application

In order to confirm or cancel the report, you need to add a button control to the app.

Step 14: Add a text input control in the app

In order to allow user input data, you need to enter text control in the app.

Step 15: Add a label control to the PowerApps application

Step 16: Create a new flow and attach it to the PowerPoint presentation

Step 17: Add PowerBI action to the flow

  • Once the flow is created, you can add PowerBI action to the flow.
  • Now set the workspace that you created in step 1
  • Set the dataset “scoreboard” that you set in step 5
  • The table created will be called “Real-Time Data”.

Step 18: Set Every field as “Ask in PowerApps”

Set every field as “Ask in PowerApps”. For the very first field, this option comes default. For the rest of the fields, you need to click on the “See More” option to set as above.

Step 19,20,21,22 has the same step. So you can add all ScreenShot in one step and ignore the rest step.

Step 19: Save your flow.

Once you’ve set all the fields, you can save your flow.

Step 20: Connect your button with the flow

Navigate to the powerapps tab and select your flow. This will add a parameter to the flow for every field in the database.

Step 21: Supply the flow parameter

Set the score flow parameter to value the rating control. Now set the below values.

Person -> TextInput

Contest -> “MBAS”

Date -> NOW()

Step 22: Save the powerApps application

Under the file menu, select -> SAVE. Name your app and select the Save button.

Step 23: Pin the PowerApps app to the dashboard

Navigate -> PowerBI tab. In the upper right-hand corner, select -> Pin Visual. Now select the Scoreboard dashboard created above.

Step 24:  Test Integrating PowerApps

In order to test, type a person’s name and select a score and update the column chart. You have successfully created an application.

I hope the above blog will help you to build and integrate the best PowerApps software. Have you ever tried such integration before? Do let us know your experience.

Are you in search of developing Real-Time Apps?

Contact Us Now

 

 


Author image

Manish Patel

Manish Patel is a Co-Founder of Concetto Labs, a leading mobile app development company specialized in android and iOS app development. We provide a one-stop solution for all IT related services.

Why Our Client Love Us?

  • Fast kick-off
  • Agile Ready
  • 98% Client Retention
  • 360-Degree solutions

Our integrity and process focuses largely on providing every customer the best recommendations for their respective business. Our clients become recurring customers because we always go beyond their expectations to deliver the best solutions.

Get In Touch
Kamika Kilgore
Customer for over 2 years Kamika Kilgore United States

Concetto Labs has been a fantastic partner in consistently delivering high quality, high value solutions to our organization. Their team does an excellent job of first understanding our processes and requirements, and then translating them into solutions that meet or exceed expectations. Concetto Labs has helped us simplify multiple processes and workflows as well as suggested additional improvements we had not considered. Their communication and follow-through are top tier. They have proven themselves to be a trusted partner and we look forward to leveraging their services on future projects.

Mr. Sieva Savko
Customer for over 4 years Mr. Sieva Savko Norway

Concetto Labs have provided us with a tremendous amount of help. Their competence in various IT fields led to a positive outcome while facing different challenges. A lot of value was given by their helpful professional staff. To describe this company in three words: effectiveness, collaboration, trust. I would also like to personally thank Mr. Tejas Patel for his positive, friendly, and highly competent approach. The all-around support provided by him made every task at hand a no-brainer.

Miss. Caroline Jack
Customer for over 4 years Miss. Caroline Jack South Africa

It has been an absolute pleasure working with the Concetto Labs team! We have worked together on a few projects now, all of which have been successful. You can rely on good communication and response times from these guys. And they go above and beyond to ensure that the result is achieved. Because of their great service, they have become an integral part of our business and we will continue to use them going forward.

Mr. Richard Bartlett
Customer for over 3 years Mr. Richard Bartlett United States

Concetto Labs is a group of incredibly talented individuals. They are very responsive and communicate with you each and every step of the process. I worked with Manish Patel throughout the entire process and must say that I have never conducted business with a more honest and professional individual. Together with his team, Manish created www.travcentiverewards.com exactly how we envisioned it to be. Thanks for all of your hard work.

Mr. Conrad Abraham
Customer for over 2 years Mr. Conrad Abraham United States

Concetto Labs team is my go-to for any simple or complex development projects. They have risen to the challenge. Great project management, communication, and super quick turnaround. I've done multiple projects with them and don't plan on changing that.

Mr. Edward Chin
Customer for over 4 years Mr. Edward Chin Canada

Concetto Labs was able to bring my complex idea to life. Throughout the project, Concetto Labs maintained constant communications and was always professional - considering I had no experience in what I wanted to create their welcoming attitude, patience, and knowledge in the field created the perfect environment to work in. I was so impressed with their work that I've kept them on board as my go-to experts. Thanks for the worthwhile experience and the breathtaking product.

Karuna Govind
Karuna Govind CTO & Co Founder (Coupay) London, UK

We started working with Concetto Labs due to the influx of work on mobile (Flutter) and frontend (React.js). It's been fantastic working with them. Good, consistent communication and good quality of work means they may be our first choice for many projects to come.

Arunabha Choudhury
Arunabha Choudhury Director (Fuzzann Technologies Private Limited) India

We are a healthcare IT company and wanted to build a Mobile Application for both Android and IOS using Flutter. The Concetto Lab team has been very patient with our project requirements and made sure all our queries are answered. It was a great show of professionalism and customer relationship. Even during the project, the team was very accommodating of all the changes we requested. The project was delivered successfully and we deployed the app in the Android Play Store. Overall, the entire process has been very transparent and the team was able to deliver exactly what we had envisioned the project outcome to look like.

GlobalClients
Good Firms Clutch App Futura Microsoft Associate Mobile App Top Developers Gesia