Using Microsoft Forms data with Power BI

Are you using Microsoft Forms to capture information and want to pull that into Power BI? Also to be able to refresh that data? Patrick has you covered and gives you some pointers.


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #MicrosoftForms #GuyInACube

[BIInfinite]

Other Method. Using Forms -> Power Automate -> capture the responses -> Push data using API (Push Datasets in Power BI service). Create reports / dashboards on top of that. As data keeps coming, Reports keep updating

[danielmudie]

When you click Open in Excel from the Responses tab of the form, it calls an api to get the Excel file. Use the developer mode in your browser of choice to capture the url of the api and paste it into PBI Desktop. That's how we did it.

[yannickfranckum]

Great video Patrick as always! I have used a slightly different approach storing data in a SharePoint list and using Power Automate to automatically refresh the Power BI dataset when a new form is submitted.

[morganmcgary]

Awesome, much easier than all the powerautomate movement stuff. Basically eliminates that layer. Good stuff Patrick!

[kingcobra]

You are the champ...
Researched number of videos including MS but none could give clear direction except when I found your lifesaving videos....Thanks a ton.

[kierstin]

Love, Love, LOVE being able to link a survey to PBI - thanks!!!

[juanitabenavides]

Probably one of the first videos ive watched from you guys and i LOVE how easy it is to follow! Thank you!

[premcst]

Don't Know how you read my mind.. Exactly what I was looking for.

[kanewoodking]

Brilliant video! I've been watching loads from your channel lately - appreciate all the amazing content you guys put out, thank you!

[IGotYoGreenCard]

I applaud you my man! I learned so much from this and was able to go step by step into creating my report for my team. Thank you!

[filipheist]

This LITERALLY saved my job!!!!
TY so much Patric!!!!

[jorgerobertobalardingarcia]

Again guys, you provided a simple and flexible solution to connect and integrate dada accorss Microsoft Platforms. Many thanks!!

[NDriStanislas]

Thank you so much Sir. I was looking for a so simple video

[lucjanooo]

Great, no more power automate needed in between forms and powerBI, thx!

[RobHOUTX]

i saw other crazy examples with building individual flows for every survey. This is MUCH easier and so straight forward! Thanks a lot!!!!

[santiagogaleanocadavid]

I searched this topic for many days... thanks a lot!

[nikishamoise]

Hi! I write the forms to a SharePoint list with Flow, then link the list to PBI. This allows me to edit inaccurate data or add missing data (lazy survey subjects!).

[reneeturner]

First time i have visited and i will be back!!!! POwer Bi rookie, and this one video helped me so much!!!! You are awesome! Thank you!

[kikalaloka]

Patrick i have a feedback form for all of my pbi reports is there a way to do this for multiple forms all at once?

[nashahan]

Patrick... you just blew my mind. I didn't know you could integrate the excel output from forms to onedrive... that's so good.