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!
Parker Stevens
Parker is the creator of the BI Elite YouTube channel, a community of over 30,000 students learning Power BI, DAX, and Power Query. He is a Microsoft Data Platform MVP for his work with Power BI and continues to provide elite Power Platform training courses to help data analysts, BI developers, and citizen dashboard creators reach their goals. Parker is committed to producing high-quality training content that is also extremely cost-effective, to ensure that the largest amount of users can benefit from the content. Training courses located at https://training.bielite.com/
2 Comments
Leave a ReplyCancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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!