Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Creating Real Time System


I need to create an ETL system which will recive data from a user through survey/Form -> the data will be stored in a database/dataset -> calculations will be done -> the calculated data will be presented on a dashboard (Hopefully the survy and the dashboard will be on the same web page/portal).

Could i use for these porpuse Power app and power BI?

What are the basic architecture/connections i need?

Thank you.

Super User
Super User

Re: Creating Real Time System

Depending on the complexity of the form and the intended audience, you may want to consider using Microsoft Forms rather than PowerApps.

PowerApps can write the data directly to your dataset. IIRC with Forms you'll need a Flow to write the responses to your dataset.

I'm not a PowerBI expert but you may want to look at the Streaming data capabilities so that changes to your data source are reflected in your visuals in real time.

Helpful resources


Watch Sessions On Demand!

Continue your learning in our online communities.


PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!


Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 4 members 4,244 guests
Please welcome our newest community members: