Forum Discussion

Danetech's avatar
Danetech
Regular Visitor
9 years ago
Solved

Power Bi & MS Forms

Can you get data from a Microsoft Form on 0365, rather than downloading the excel spreadsheet and using that.   Thanks :smileyhappy:
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Danetech,

    You need to  embed Forms into a web page, get a web url, use the URL to get data.

    Best Regards,
    Angelia

fduran's avatar
fduran
Advocate I
7 years ago

Does anyone know if Microsoft has any plans on creating a connector for MS Forms?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    fduran wrote:

    Does anyone know if Microsoft has any plans on creating a connector for MS Forms?

    This is the correct question. PBI just needs a connector. Have several tests, training and retraining datasets that I would love to at add Microsoft forms/quiz results to for better reporting in my PBI apps

    • DeanWHall's avatar
      DeanWHall
      Resolver I
      6 years ago

      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.

       

       

      • renaudstaessens's avatar
        renaudstaessens
        Helper I
        6 years ago

        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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have several forms that were created from within sharepoint, so the associated excel file is visible in our sharepoint site - I cannot get PowerBi to read from these

     

    If the same folder, I have a "Master File" which is populated via MS flow whenever an entry is made using any of the forms - This one I can get power BI to read setting up as

    Get data>web>(link to the file minus everytihing in the address after the .xlsx)

     

    I don't understand the different behaviour. I would like to try and get Power BI to read the excel files from each individual form and combine so I can bypass the MS flow part