Forum Discussion

Blake753's avatar
Blake753
Icon for Helper II rankHelper II
6 years ago
Solved

Same Questions Multiple times in Microsoft Forms

So I have a Microsoft Form that is pumping data into an online excel sheet.  The form is gathering data from workers to see how many accounts they completed that day and for which facilities.  For ex...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Blake753 ,

     

    This might be helpful.

    • 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.

    Refer to this thread:https://community.powerbi.com/t5/Desktop/Power-Bi-amp-MS-Forms/td-p/164042/page/2 

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Blake753 ,

 

This might be helpful.

  • 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.

Refer to this thread:https://community.powerbi.com/t5/Desktop/Power-Bi-amp-MS-Forms/td-p/164042/page/2 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.