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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Danetech,

Please click Get Data->Web->type your Ms forms link, click OK and load the data. And check if it works fine.



Please feel free to ask if you have any other issue.

Best Regards,
Angelia

Danetech's avatar
Danetech
Regular Visitor
9 years ago

This is what I see when trying the top URL - not much data :smileyindifferent:

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Danetech,

    There should be more data in the document? The one row returned is belond a part of the document?

    Best Regards,
    Angelia

    • Danetech's avatar
      Danetech
      Regular Visitor
      9 years ago

      Yeah, there should be a lot more data, the data returned is not part of the doucment.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        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

  • revansh's avatar
    revansh
    Helper IV
    8 years ago

    Hi Danatech,

     

    Were you able to resolve this issue.

     

    Thanks