In this Power BI tutorial, you’ll learn how to connect directly to Microsoft Forms within Power BI. A lot of other tutorials explain that you need to perform a workaround to get your Forms data, but that’s not true anymore! It looks like Microsoft Forms has released an API (maybe unofficial, not sure). We can use this API to get all of our form submission data directly in Power BI. All you need to do is use the built-in Web Connector, meaning the data will be refreshable in both Power BI Desktop and Power BI Service 😁
I hope you enjoyed learning this advanced trick! If you liked it, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!
Have you found that this still works? I get error DataFormat.Error: External table is not in the expected format with references to .xls. When I download the workbook directly in the form, it’s an .xlsx. Hard to troubleshoot since the API is unofficial.
Hi Parker, Thanks for this trick! It works like a charm.
Now I am struggling with getting my published (using the “Publish” button in Power BI Desktop) dashboard automatically refreshed.
Another trick maybe ?
Thanks a lot!