survey fed to instant online dashboard

[Anonymous]

Hi all,

I have a general question - not sure if this is the right place to ask but any help would be much appreciated. 

This is the general process I am trying to create:

1. A person is given a survey to complete (microsoft forms or otherwise)
2. The data from the from is manipulated to get it into the correct format
3. The clean dataset is fed into a power bi dashboard
4. The person is either fed a link/page redirects to an embedded power bi dashboard visualising the results of their survey.

Not sure if this is even possible with forms/power BI but again if anyone can point me in the right direction as to whether it can be done or other technologies I might need to use instead, that would be awesome.

Thank you in advance!

[lbendlin]

It can be done, but not really real time.

Use Forms, Power Automate, and hybrid streaming datasets

Set up a flow in Power Automate that triggers when a form is submitted, and that then pushes a data row into the streaming dataset you created earlier. It has to be a hybrid dataset else you will lose your submission history.

An alternative would be to write the data row into a SQL database, and then initiate an API refresh of a regular dataset (that is pointing to the SQL source), with the dashboard feeding off the dataset.

And yes, you _could_ use Sharepoint lists to store the form data, but Sharepoint list fall over very, very quickly.