Forum Discussion
Power Bi - Link to Microsoft Form Spreadsheet
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
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-0mvp3n4UHi 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.
3 Replies
- vojtechsima
Super User
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 
Uzi2019Community Champion
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
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.