Forum Discussion
Linking form responses using Power Query
I want to have a Form linked directly into a Power Query Excel file so that when responses are added, the data source can be automatically refreshed and the user can see the new pivot table. I have ...
Just so you know, I ended up with a clunkier solution of downloading the new file into an Excel file that had the cleansing on it and refreshing. it's not ideal - but given the alternative option the user was going to do, much better. 🙂
agwalsh I learnt from the section https://www.howtoexcel.org/general/microsoft-forms/, linked as the text. It was clueless how to form a live response data collection until I came across this article. Before starting any edit, please Open in Desktop App. I managed to create an excel data file with queries on SharePoint link with my form responses at the first tab. Using Power Query as a second tab for table calculation and total score evaluation. After completing all the data analysis, remember to autosave so it will sync the data back SharePoint. Hope this helps.