Power Bi - Link to Microsoft Form Spreadsheet

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

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!

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.