If you have not read the MS Flow Integration article, please read that first before beginning this tutorial.


Okay, now that we have got to the Pares JSON connecter all setup we can take the form data and integrate into other back end systems.

This tutorial is focused on Power BI integration and more specifically 'Add row to dataset' connector.


Set Up Dataset


Datasets can be used to fuel your graphs and charts in your Power BI dashboards.


To create a new dataset navigate to your workspace, select the Datasets tab and click Create. 

Then select streaming dataset, and API.




Now you can build out your dataset. For this you will need to name your dataset and start adding values.

These values will be the form data that you want to capture in the dataset. Datasets offer 3 value types, text, number, and DateTime. 




Now that the dataset is complete we can connect the Flow.


Connect MS Flow


Open MS Flow and search for the Power BI 'Add row to dataset' connector. 

Now start connecting the Workspace, Dataset and table.

Once these have been set the dataset values will automatically appear. Now it's just a matter of connecting the correct dataset value to the Form data. 




Make sure to save your flow changes, and your DONE. Try submitting a form and seeing if it starts to populate your dataset. 

You are able to see if the flow ran successfully by clicking on the flow and looking at the Run History.