Thanks for sharing!

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

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

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!

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)

Power bi is very powerful unboxing 😉👍

Thank you!

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

@HowtoPowerBI

3 жыл бұрын

Glad you liked it! 😀

Thank you! This video is so helpful!

@HowtoPowerBI

2 жыл бұрын

:) 👍 great thx!

Amazing!

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

@HowtoPowerBI

3 жыл бұрын

thx Roberto! 😃

Very well done video. Thanks for the education.

@HowtoPowerBI

3 жыл бұрын

Thanks for watching Christopher!

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

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

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!

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?

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.

Very nice! thanks Bas

@HowtoPowerBI

2 жыл бұрын

Thanks for your kind words :)

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?

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

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.

Great video 🔥

@HowtoPowerBI

Жыл бұрын

Thx Rajat :)

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?

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

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

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

3 жыл бұрын

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.

Thanks

@tomoyat5517

2 жыл бұрын

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

2 жыл бұрын

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

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

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)

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 .? :(

like your muscles and beard and also the awesome tricks

@HowtoPowerBI

3 жыл бұрын

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

@sandymaverick4702

3 жыл бұрын

@@HowtoPowerBI quality content. Keep it up

@timpullen398

Жыл бұрын

@@HowtoPowerBI Perfect answer

Hello I m trying to automate in a PBI dashboard which is using email data I have column in mail box where i m mentioning mail IDs i want to notify from Powerbi to the mail id mentioned person I m unable to connect the pull data in power automate i have tried in power visu as well but I can't see data over there

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

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

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

@HowtoPowerBI

2 жыл бұрын

yes 🙂

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

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

3 ай бұрын

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

Can we skip that ondrive part??

work with MS quiz??

@HowtoPowerBI

3 жыл бұрын

I think so 🙂