connecting MS form with power BI

[Apple08]

Hi All

I need to connect a Microsoft survey form Excel result automatically with Power BI.  Please could anyone advise what is the easiest way to do and how to do it.  Many thanks.

[Apple08]

Thanks, I did watch it and try, however I got the credential denied issues.  I am not sure where should I get the first URL as stated in the video:

Please could you let me know how I can get this URL?

[pratyashasamal]

Hi @Apple08 ,
In Microsoft Forms, open the quiz or survey you want to share. Click Share. On the Share pane, click Get a link to view and edit. Click Copy next to the text box that displays a form URL.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Apple08]

Thanks.  I did that earlier but it didn't work.  I found someone has the same credential issue at:

https://community.fabric.microsoft.com/t5/Desktop/Connecting-Microsoft-Form-to-Power-BI/td-p/3089834

I can't see the 'Share' option therefore I used the link stored at the 'collaborate or duplicate', I noticed both the question and the response links are having the same id keys.

Question link: //forms.office.com/Pages/DesignPage.aspx?subpage=design&Formid=(hidden)

Response link: //forms.office.com/Pages/ResponsePage.aspx?id=(hidden)

I have hidden both keys but they are exactly the same.  Not sure whether I have made any mistakes or this method doesn't work any more. 

[pratyashasamal]

Hi @Apple08 ,
You can follow this youtube video to connect MS forms with Power Bi.
https://www.youtube.com/watch?v=HupBVO1P8_M

Hope this was helful.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C