From a form to a Power BI dashboard

Analyzing the survey data on our dashboard more deeply can be done simply if our form was created in Excel. We just connected our Power BI to the source Excel file and thus built the charts; however, most Microsoft forms are not created this way.

To analyze the answers of forms that were not made in Excel, it is necessary to export the answers to be able to use them as a data source in Power BI. This manual work makes it difficult to act and analyze in real time, which is required in certain scenarios.

Let's use an example of a form that is available globally to collect complaints about environmental deforestation. The faster these complaints appear in the indicators and generate alerts, the more chance there is of action being effective. To technically set up this scenario, we will use three tools that we have already seen in this book (Microsoft Forms, Power Automate, and Power BI), and with them, we will have the form data in real time...