Forum Discussion
Power Bi & MS Forms
Hi Danetech,
You need to embed Forms into a web page, get a web url, use the URL to get data.
Best Regards,
Angelia
I have a fully workign solution that is easy to implement for Froms to Power BI.
- Create an Office Group (you will have some already) to contain your Form
- In the Forms start page switch from 'My Forms' to 'Group Forms'
- Create a new GROUP FORM - this is the step that makes it all work...
- Add one entry to test data capture (needed to trigger the data capture behind the scenes)
- Go to review responses by selecting you completed form
- The screen will present some results, but just under the Ideas icon on the right you have the option to open the results in excel - do so now..
- This file, you can connect to using GET DATA in Power BI as it resides in a document library on sharepoint for the group you selected earlier. I use the option to connect to a 'SharePoint Folder' to connect and not File.
- Away you go and design your report.
One point to note that has caught us out is that the questions themselves are the column headings for the table so if they change a quesiton - data model could break ! - I get around it by not using the promote headers option and hard coding column names but if your quesitons are fixed it will not be an issue.
Hope this helps.
ortunately this procedure seems to work ONLY for forms not Quizz as when i do the same with quiz when you click on "open in excel" button the file is downloaded on your computer and not opened in a sharepoint file ... any workaround to force it to be saved on the sharepoint site?