Business Application of POWER AUTOMATE | Connect MS Forms with Power BI

[@kylerayner1103]

Always love your content. Great job. One Note:** If the MS Form is created within a M365 Group, the connected Excel document is static in a folder in the group's SharePoint. That means that you can use the Excel data connection to bring it directly into the PowerBI file and publish with a refresh schedule. No Power Automate needed for this one, but you could still use PA for the email alert!

[@sunnyboy6433]

What a brilliant way to walk us through each steps. Your approach is easy to follow. Good content. Thank you.

[@kishore_p93]

Thanks for sharing this wonderful feature. Appreciate your efforts! 😊

[@HowtoPowerBI]

Glad you liked it! 😀

[@superlaffin39]

Your channel is the only channel I subscribed. I don't really subscribe to any kind of channel, not even those I watch video regularly, except yours. You are a very good content creator and your videos are all useful and knowledgeable.

[@HowtoPowerBI]

Wow, thanks! This totally made my day :)

[@alexrivera6524]

Thank you so much for putting this together! 👏🏻👏🏻

[@norahudec]

Thanks for this video, you helped me a lot!! Is it possible to connect MS Forms with Power BI desktop as well?

[@RajendraPatel.]

Power bi is very powerful unboxing 😉👍

[@erikdessiex1026]

Great video, it really sums up the different ways to link forms with Power BI. There is another alternative, which was to use get data as Web, and using the Forms Link as a URL (slightly modified though)

[@spen2431]

Thanks for this. Quick one - Would it have been easier to start your MS form from Excel online? This automatically places it in OneDrive and saves the power automate stuff? (or some of it)

[@HowtoPowerBI]

Yes, you are right. When you just want the answers from MS Forms and then save them to excel on onedrive solution that is defintily easier. I would go for power automate when I want to have a whole flow of different things to happen or when I need to write to an excel file with a different trigger than MS Forms.

[@nainanramesh3208]

Hey there, quick question... I've all your steps and it's working just fine... I had to delete some responses in FORMS, but somehow it's not getting into PowerBI ... How do I go about?

[@robertoantonioguzmanvegas3349]

Thanks very much for sharing and your efforts.. Great video!.

[@HowtoPowerBI]

thx Roberto! 😃

[@Bedaywee]

Is it possible to use the data on PowerBI desktop instead of the cloud PowerBI? If yes, what is the procedure?

[@chrisbarnes1]

Very well done video. Thanks for the education.

[@HowtoPowerBI]

Thanks for watching Christopher!

[@minstreltokunbo]

Thank you! This video is so helpful!

[@HowtoPowerBI]

:) 👍 great thx!

[@kirylbudnik8262]

Thank you for this great tutorial) Is it possible to create a power bi report based on each individual response and send the resulting report to each individual respondent? Would it involve power apps or you can use only forms, power bi and power automate?

[@thestu4602]

Thanks for sharing!

[@oariasz72]

Excellent videos! Something I haven't been able to find the solution to. How can I export a PBI Report data to an Excel file in a local directory? There seems to be a kind of express prohibition from Microsoft to do something so basic. Thank you!

[@joaomartins2431]

Thank you!

[@deepakgautam8958]

Hi Bas, You did a great effort in this one. I have one situation that is complex for me so I am looking for some feedback and insight on it. I would like to integrate with Power BI as well. For example, I am creating a form for entry purposes for my hub's programmes reporting. I have 8 hubs and 14 programs that are operated for customers. At the end of the day staff from each hub will enter the events that happen in a day. And I like to create a single form that does all tasks. for instance, if I choose Hub A, then it allows me to select Program 1 then allow me to enter subsequent answers like the number of attendees, time of the event and some questions come along. And if I select program 2 then it should let me enter subsequent answers similarly. I tried to do branching and I find it more challenging. So would you guide me with some insights? Rather than creating separate forms, I would love to integrate all through 1 form and have under the same data sets to analyze. Can anyone share the similar experiences I am facing?

[@timpullen9752]

Thanks for great content - I have managed to get the forms data pull though using Power Automate - For some reason the totals within a quizz do not pull though. If I look at the results in Forms the points are there, however the points score for the quiz don't come through in the data. Any Ideas. I hope someone can help.

[@NeshaStanic]

Nice. But, here's the catch. I have a Form that occasionally needs to be changes with some new questions added than removed. So, how to cope with this kind of Form vs Excel? My Excel file won't recognize these changes, it's all messed up after first removals I've made... (At the beginning, I opened empty and new Excel book on the web, than from there Create Form. This way I don't need to open Excel file after someone fill the Form, answers automatically goes into that Excel file)

[@avnish219]

Amazing!

[@hectorrosasl]

For a big amount of data, what do you recommend? Save it through sharepoint list or excel or directly to PowerBi? As of today I have around 32k rows and counting

[@HowtoPowerBI]

32k rows is still "small" , so any of these options would work well.

[@sonsangsom]

Very nice! thanks Bas

[@HowtoPowerBI]

Thanks for your kind words :)

[@rajatbhamare2785]

Great video 🔥

[@HowtoPowerBI]

Thx Rajat :)

[@AbhilashGodi]

hello can we combine 3 different streaming datasets together? appreciate your help

[@johanynavarro8065]

Hi master!! Would it be possible to select an item on a table and edit it with a PowerApps edit form on a second page?? can't find an example to guide me... Regards from Malta

[@venugopalaraochappidi4261]

Thanks!

[@venugopalaraochappidi4261]

need help refining a step in the flow where a csv file created with data of power bi report will be saved in a user's one drive based on his/her credentials.

[@jyotsna_vats]

Hi I have a question Pls reply to this My responses are not automatically saved in excel sheet why???? I have saved in One drive but still its not showing. pls help

[@michaelrezaei6200]

can respondent upload an excel file and that is pushed to a dashboard?

[@SplatpSs]

Hi, can you connect multiple MS forms into one power BI?

[@HowtoPowerBI]

yes 🙂

[@Akshita9614]

under, "Add a row in a table" , when I mention location as "One drive for business" and Document library as :"One Drive", I am not able to locate my saved file in Excel Online. Though my file is stored in One drive .? :(

[@petejones7532]

Great video. Not your fault, but the whole process for having PBI automatically refresh when new content is added is very complicated. I would have thought that Microsoft would have made this simpler! Need a real time solution that is simple to set up.

[@tomoyat5517]

Thanks

[@tomoyat5517]

Thank you for this video Recently I am on board with O365 with new apps (power automate etc) it is exciting to see how It worked across different apps. I hope you will continue sharing this kind of video as well as usual Power BI ones.

[@HowtoPowerBI]

thank you so much Tomoya for supporting the channel, means a lot to me 😀! I will try to do more of these type of videos as well going forward

[@arunaggarwal1663]

How i can change environment in power automate visual in power bi ?

[@sandymaverick4702]

like your muscles and beard and also the awesome tricks

[@HowtoPowerBI]

😂 working with all those 'power' tools makes your muscles grow 😜

[@sandymaverick4702]

@@HowtoPowerBI quality content. Keep it up

[@timpullen398]

@@HowtoPowerBI Perfect answer

[@zakarie]

I have similar problem where each of my team member is going to update their project status update. So I created this form but need to save each member their own sheet, how is that possible because right now all answers are saved in one sheet . I would highly appreciate if someone can give me directions on how to do it

[@ammanscorpion03]

Can we skip that ondrive part??

[@antoniyc138]

work with MS quiz??

[@HowtoPowerBI]

I think so 🙂

[@invectus7171]

How do you handle the column in power BI, if one question has multiple choices to submit in forms?