Linking form responses using Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1462832%22%20slang%3D%22en-US%22%3ELinking%20form%20responses%20using%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462832%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20have%20a%20Form%20linked%20directly%20into%20a%20Power%20Query%20Excel%20file%20so%20that%20when%20responses%20are%20added%2C%26nbsp%3B%20the%20data%20source%20can%20be%20automatically%20refreshed%20and%20the%20user%20can%20see%20the%20new%20pivot%20table.%20I%20have%20tried%20linking%20the%20Forms%20link%20via%20From%20Web%20(didn't%20pick%20up%20the%20data%20in%20the%20form).%20Tried%20the%20same%20thing%20with%20the%20link%20that%20gives%20the%20summary%20of%20responses%20-%20same%20problem%20-%20got%20stuff%20about%20Document%20and%20then%20Kind%2FName%2FChildren%2FText.%20What%20am%20I%20missing%3F%20I%20searched%20for%20this%20but%20just%20got%20something%20about%20embedding%20in%20a%20webpage%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1462832%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

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 tried linking the Forms link via From Web (didn't pick up the data in the form). Tried the same thing with the link that gives the summary of responses - same problem - got stuff about Document and then Kind/Name/Children/Text. What am I missing? I searched for this but just got something about embedding in a webpage? Thank you

4 Replies
Highlighted

same help needed here too

Highlighted
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. :)
Highlighted

@Anne Walsh I learnt from the section Creating a Form in SharePoint, 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.

Highlighted

@yizhimooThank you very much for that - it's really useful. That's a well explained article - oddly enough I used something else from that website yesterday for a tutorial on SharePoint :)