Millington Offices (10).png

Power BI Streaming Datasets and Forms: keep your audience engaged with real time data

Updated: Dec 1, 2020

I rarely use Power BI Streaming Datasets, but when I do........ I have to say, they are awesome for meetings, workshops and trainings!


In this post I’m going to talk about feeding your Power BI Dashboard with live data from Microsoft Forms (with a little help from Power Automate).


When you have your final solution in place, you will be able to see your Power BI Dashboard refresh automatically every time you submit a Form, real time data streaming folks, exciting!



Key words: Power BI Streaming Datasets, Power Automate, Microsoft Forms, Real Time Data



#Realtimedata




1) First, we will create our form. To do this open Microsoft Forms and create the form you want to present to the users, and that will lately feed your dashboard (choose your questions well 😉)


https://forms.office.com/Pages/DesignPage.aspx


Some help on how to create forms:

https://support.microsoft.com/en-us/office/create-a-form-with-microsoft-forms-4ffb64cc-7d5d-402f-b82e-b1d49418fd9d



I have added 4 questions to my form, you can add more or less depending on your needs:



2) The second step is to create a streaming dataset. To do that open the Power BI Service webpage, select the Workspace you want to create your streaming dataset on and click on New > Streaming Dataset: