Forum Discussion
Connecting Microsoft Form to Power BI
Hello, I'm trying to connect my microsoft form data to Power BI, i tried following this tutorial : Easiest Way to Connect to Microsoft Forms Data in Power BI - BI Elite and my URL does the same ...
One workaround I use is to host an excel sheet on SharePoint. I use PowerAutomate to add each new response to the excel sheet as a new row. This also allows me to edit responses as needed. It is easier to change one cell in excel than it is in Power Query/Power BI. However, I have a need for a form where responses can be revisited and added to/amended. If anyone has a method of capturing data from the form directly that can refresh old form submissions that were updated, similar to an API as opposed to a flow of resopnses to a new static data storage system, please let me know! This would be very very beneficial!