Power Bi - Link to Microsoft Form Spreadsheet

[Bankesy26-_]

@dk_dk @FotFly @SamWiseOwl 

Good morning,

As the three of you combined to help me with my introductory query regarding graphs last week I'm wondering if any of you can help me with how I might be able to link Power Bi to a spreadsheet that gets populated with answers from Microsoft Forms, please?

I've got the form created and the spreadsheet is automatically generated and populated but I suppose what I'm getting at is the possibility of a 'live' link to it from Power Bi so I don't have to save a copy and import anytime I want to run analysis.

All suggetions welcome.

Kind regards

[vojtechsima · Accepted solution]

Hello, @Bankesy26-_ ,
I am not the guy, you tagged, but here's the video that helps you step by step creating streaming dataset so you can fetch the answers live:

https://www.youtube.com/watch?v=XG-0mvp3n4U

[Uzi2019 · Accepted solution]

Hi @Bankesy26-_ 

check this video for better understanding.

https://www.youtube.com/watch?v=HupBVO1P8_M

https://www.youtube.com/watch?v=XBFVDedwLiY

https://www.youtube.com/watch?v=ksHGan0ulQM

https://www.youtube.com/watch?v=ie7HB6yv8qM

I hope above video would help you resolved your query.

I hope I answered your question!

[danextian · Accepted solution]

Hi @Bankesy26-_ 

Open the Excel online file and and edit it in Deskop app. Go to File >> Info and copy the path. Remove anything after xlsx which is usually ?web=1. Use the web connector to connect to this file by authenticating using  your MS 365 account.

[Uzi2019 · Accepted solution]

Hi @Bankesy26-_ 

check this video for better understanding.

https://www.youtube.com/watch?v=HupBVO1P8_M

https://www.youtube.com/watch?v=XBFVDedwLiY

https://www.youtube.com/watch?v=ksHGan0ulQM

https://www.youtube.com/watch?v=ie7HB6yv8qM

I hope above video would help you resolved your query.

I hope I answered your question!

[vojtechsima · Accepted solution]

Hello, @Bankesy26-_ ,
I am not the guy, you tagged, but here's the video that helps you step by step creating streaming dataset so you can fetch the answers live:

https://www.youtube.com/watch?v=XG-0mvp3n4U