Forum Discussion
Vikas Dhingra
Nov 21, 2018Copper Contributor
is there any way to connect MS Forms responses directly in the Power BI instead of storing in excel?
I want to use the MS forms response in PowerBI to generate reports, but I have to export data into excel and then I can connect it. is there any other direct way to connect MS forms with Power BI?
Matthew Parowski
Oct 16, 2020Brass Contributor
Vikas Dhingra Yes, you can use Group Forms. If you don't create a form directly through MS Teams so that it is embedded in a Group, you can move the form into a group. (On the Forms home page, before clicking into a Form, hover over the form, click the "..." in the top right; select "Move"; pick the Group where you want to move the Form.) You can get to group forms using the menu at the top of Forms. It defaults to "My Forms", but "Shared with Me" and "Group Forms" are the other options. Once it's in a group, find it under Group Forms.
Once you open the form, click Export to Excel. This is the key difference: the Excel document does not download, but rather is saved in the Team's file folder structure. You can get the URL for the workbook by opening it in Excel and going to File --> Info --> Copy Path. You can put this into Power BI's Web connector. As new submissions come in to the Form, they will automatically be added to this same Excel file, so you can do a standard refresh. No PowerAutomate required!
ubk96
Apr 26, 2024Copper Contributor
Hi,
This Export option not coming to me
This Export option not coming to me
- DingkunXieApr 26, 2024
Microsoft