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

dave500's avatar
dave500
Regular Visitor
7 years ago

I'm curious too - has anyone got this to work using any of the solutions mentioned above? I'm also having difficulty connecting to MS Forms 365 using the embedded URL approach.

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
7 years ago

This might be helpful.

I found a workaround by using the API Streaming Dataset in Power BI. I have a Flow connected to my Form and it populates to that dataset each time a new Form is submitted.

This video was helpful to achieve it

https://www.youtube.com/watch?v=rRrCqdWbT-U