Easiest Way to Get Microsoft Forms Data in Power BI

[@kwaaikraai]

Wow! Probably one of the most useful videos on KZbin right now! Thank you very much, Parker!

[@BIElite]

Thanks Wilhelm! Glad to hear it.

[@gw-j]

Not sure if this has been borked by M$ but I had a form that was working perfectly for the last couple of months that yesterday started to generate errors upon refresh. Error was with authentication and now when try to update the authentication with Organizational Account I get the error "The WWW-Authenticate header doesn't contain a valid authorization URl. Header value: 'Bearer'.

[@hugopaes1608]

The same had happed here, it was working perfectly but today when I tried to refresh I got this error "The WWW-Authenticate header doesn't contain a valid authorization URl. Header value: 'Bearer'." too. Could you please help to reactivate or generate an another valid API? @BI Elite

[@Kkacziii]

​@@hugopaes1608 the same problem​

[@chukachukwu]

Same for me, tearing my head out. Issues is currently impacting 2 of my reports in Production 🤦‍♂🤦‍♂. Has anybody found a fix?

[@clairemaynard7279]

@@Kkacziii Same problem :(

[@samfischer419]

Same here :(

[@yehudabuaron5216]

Thank you! I'm using this method for a long time. But suddenly its stoped working and it says that "The OAuth authentication method is not supported for this data source." Do you know something about it?

[@scorsellt1229]

Oh man this is has to one of the most useful BI videos I have seen for a while, thanks Parker!

[@BIElite]

Hah, great to hear!

[@richardlindgren5875]

I'm running into authentication issues when trying. Freely translated the message is "This type of authentication data is not supported by this resource." This is before I even get to give my credentials. Any idea?

[@anonname7610]

This, it doesnt work

[@dannyfaithful]

Same issue, do we have any solutions?

[@fathimasafana9598]

Remove :x: from url

[@mayobi]

I have an error when I try to connect with my organizational account. "We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type."

[@KK8-020]

I'm getting this now too! how did you fix this at the time?

[@mrneveradullmoment]

Same...

[@vivekkoli4479]

Same here, were you able to find the resolution on this ?

[@cheapdomainnames]

Thanks, I tried. but when signing in with Powerbi Desktop. it comes back with. "We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type." Do you know if this is still valid for the latest powerbi version

[@mrneveradullmoment]

Same...

[@123batman1000]

Thanks for your videos. Passed DA 100 by watching your video and ofcourse practice powerbi daily.

[@BIElite]

Great to hear that, Sayeed. Congrats!

[@big3067]

just watched this tutorial however connecting via the web has now disabled as of April 2022, are you still able to do it as a direct to form from Power Bi ? I prefer to not create a forms for excel or power automate it to a SP List .

[@kateapanovich5639]

noooooooo!!! Did you find another way to connect to it via oAuth or something? This solution is soo goood! I also do not want to create a SP list and flow for this. so long for nothing

[@raghukalyan7126]

Hi, how did you get url (API) in your notepad

[@juliorosales5160]

I am wondering, how ca we automate the maxResponseId so it goes up once the list in the form is greater than 1k responses

[@HavensConsulting]

Slick Parker! Forms is a fantastic data collection tool, and I never knew you could connect direct via URL. I made a similar video a few years ago connecting forms to a Power BI streaming dataset through Power Automate.

[@BIElite]

Nice man! Yeah I've been looking for an API endpoint for some time now.

[@HavensConsulting]

@@BIElite it's a fun way to collect data at trainings and/or presentations. Have everyone take their phone out, snap a QR code on the screen. Then as people fill out the survey they watch in real time as a Power BI report populates data. Gets them more excited about Power BI

[@allonewordlowercase]

Create the Form through teams or sharepoint and you can access a spreadsheet easily connectable in to PBI

[@loiclevan]

The method has worked for months and now the Organizational login is not possible with error message: The WWW-authenticate header doesn't contain a valid authorizatoin URI. Header value: 'bearer'. Has someone experienced this, too?

[@pranaysharma8694]

Yah I am facing this, were you able to get around this issue?

[@hugopaes1608]

Me too, got the same error. I'm trying something fresh. Get you know if I achieve something.

[@tnsparks]

Same problem here, if anyone learns how to fix this please share!

[@clairemaynard7279]

Same here :(

[@tnsparks]

I found a workaround solution. It requires the form be part of a group. Then you can pull the excel doc and it should be opened in a sharepoint file. From there you can copy path for the file and input into BI. If new entries are made, you can refresh your BI report and it shows the new entries as well :) Hope this helps everyone else with these issues. PS. only the owner of the form can move it to a group.

[@PaulBailey3]

I wish this was an easier process from MS, but your solution is nice and elegant.

[@SteveWinward]

Great video! The API URL you show seems to cap the output to 1,000 responses. Is there any way to page through the API to aggregate more than 1,000 responses?

[@BIElite]

Take a look at my video on looping in Power Query! The link is in the description.

[@faillerplays]

how do i append forms answer to an existing power bi table?

[@dlcolegrove6112]

I used this in December 2021 to make a query that pulls from an in-use form, and then it broke within the past week. It won't authenticate. I still have access to all data and see it, but the code to pull into the dataset is not working because it can't authenticate. I suspect something happened on my organization's network, but I'm curious if anyone else has seen this. Error: The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer'.

[@tnsparks]

Same problem here and several people below. I have not seen a solution or work around to this yet.

[@wunanjun8804]

@@tnsparks I got the same problem

[@gabrielferreiraguimaraes2092]

Great tutorial, but I need to know the quiz score in addition to the start time to calculate the duration of the assessment. Is there any way to get this data?

[@stevendavies3934]

This has stopped working for me as well. I can no longer access the data in Power Bi

[@hugopaes1608]

After day 04/05/22 it stopped working. Outdated API I guess. It was working perfectly but today when I tried to refresh my report, I got this error "The WWW-Authenticate header doesn't contain a valid authorization URl. Header value: 'Bearer'." too. Could you please help to reactivate or generate an another valid API? @BI Elite

[@clairemaynard7279]

I got this error too :(

[@dlcolegrove6112]

@@clairemaynard7279 Same here. Very curious if anyone figures out a solution.

[@Martl1974]

for me the same. I've opened a MS Ticket.

[@GieBaNa]

Same here

[@bernhardlipka7523]

Enjoyed your Video. But how would you connect Power BI to the Forms survey data in Microsoft Teams? Nothing I've tried works.

[@liu6896]

can we still find the api now (2024) in Microsoft form?

[@AldoniSinaga]

This is what happen when i try to sign in : We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type. anybody know the solution ?

[@ntombekazisibetyu]

Hi, i'm getting the following errors when i try to connect to the web content :unable to connect because credential type is not supported for this resource, any idea how to solve this?

[@theogeorgas4232]

I get a msg "We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type."

[@jamesschuldenfrei2485]

I'm getting the same - any tips here would be greatly appreciated

[@erinfield1943]

Very cool. What if you have the opposite issue though- you want Power BI to generate inspection forms for different inspectors depending on what sites they click on on a map. How could you get those forms e-mailed to the user?

[@sps425]

How do you analyze different forms data kn the graph I.e feedback responses per program comparison?

[@rumwhiskeyteq8227]

@BI Elite Hey does this method automatically update the dataset with new responses?

[@dlcolegrove6112]

You can setup scheduled refreshes of the data, so it won't be instant updates unless the form was filled out right before a scheduled refresh. However, this method is currently causing issues (sort comments by newest) for those of us that have been using it. We're all getting authentication errors.

[@kingboo302]

I have run into the exact same authentication error that others are mentioning. Glad to see its not just me. But sad to see since this video used to help me so much. the workaround i found that will hopefully help others 1. Open MS Form 2. Click “Responses” tab 3. Click “Open in Excel” 4. Then open the excel file in Desktop Mode 5. Click “File” 6. Click “info” tab 7. Click the button that says “Copy path” 8. Open PowerBI in desktop 9. Click “Get data” 10. Click “Web” 11. Paste the link from Step 7 12. BEFORE clicking “ok”, remove the “?web=1” so the URL ends with .xlsx 13. Click “ok” 14. Click “Table1” or “Form1” not sure what the difference is. Maybe someone can explain to me. 15. Click “Load” 16. And that should be it! Your data is downloaded

[@ricecurryman]

Unfortunately that would only be a static version of the data, you would only have the data up to the point you downloaded that spreadsheet. My fix was to copy all the existing data to a new spreadsheet and use power automate to append new survey submissions to the new spreadsheet. Use the when a new response is submitted trigger, then get response details, and add a row to table. And use the new spreadsheet as the data source in power bi.

[@tnsparks]

@@ricecurryman No if the form is saved in a team, then the responses will open in a cloud shared excel file. I have used this method and my responses update when my report auto refreshes.

[@kingboo302]

@@ricecurryman ah yes that is a good point. i forgot to clarify that my method will only work for those that have shared the data in Teams/Sharepoint where it is automatically collected. do you have a video of your method?

[@raphaelqueiroz691]

Thanks man 👏👏

[@oliverfinkelstein8826]

I am stuck at credential step. I keep getting error of “we were unable to connect because this credential isn’t supported for this resource. “

[@ThepExcel]

Wow! Thx a lot

[@BIElite]

No problem!

[@ronnyerpelding9992]

Excellent ! And it works also with excel, just add a source like in Power Bi.

[@SplatpSs]

Can you connect multiple MS forms into a Power BI file?

[@syafiqfathyamermohd6255]

Hi, May I know how do you get the file URL? I tried to find but still can't find it.

[@BIElite]

Hi there, I simply opened up my form and it gives you the form id. Then you can simply plug it into the URL I showed in the video.

[@kslivkin]

Hello, thanks for the video. How to increase the number of responses?

[@lenzypetty9371]

I found Refreshing to be inconsistent. Manual refresh works in Desktop, but not in PowerBI Service

[@aloulouanis]

Thank you very much for this solution. It worked for me very well for 2 months but from last week I have an error (without changing anything!). In power Bi Desktop, it is required to identify again, I choose professionel account as in the video when u add the data for the first time. But the account is not recognised and i have this error: WWW-authenticate header does not contain a valid URI autorisation. header value is: "Bearer". Does someone know how this error can be explained? thanks in advance

[@poweruserwithcrashlongjohns]

Since I even found this to be a nice solution vs having to either do a MS Form, Automate, SharePoint combo or just a MS Group Form to have the excel automatically in SharePoint created to tie to BI and having same results as others for some time wanted to post update I found out. MSFT looked into it for me and seems that this was never suppose to work in the first place as designed. Since at some point they fixed the glich this solution is no longer valid. So, back to either a Group MS Form if just needing the data and not doing any intake actions on said data or if one is like a process request then MS Form, Automate, SharePoint combo solution which then BI can tie to ones SPO list. Hope this helps others and spares possible loss in time or fustration. Cheers! 🙂

[@brodieleeson4977]

Thanks for this, was scratching my head for a solution but I guess its time to revert to my Sharepoint group method.

[@martinbubenheimer6289]

Seems like MSFT turned off the authentication workflow for the forms API. That means, you cannot log in from Power BI anymore using the Web connector. Now you need to implement a custom connector that handles the login procedure. Therefore, you can also read the list of forms (surveys) from the URL, then load all responses from all forms automatically to Power BI. No more need for changes in Power Query after adding a new form.

[@poweruserwithcrashlongjohns]

@@martinbubenheimer6289 implementing a custom connector not everyone can do in their organization due to corporate controls/costs associated. For low-code no code the MS Form, Automate, SharePoint list combo for the most part everyone in an organization can create themselves this solution vs a custom connector which would require IT to build.

[@martinbubenheimer6289]

@@poweruserwithcrashlongjohns Yes, both solutions have their use cases. I'd also recommend to a beginner considering the Power Automate approach as long as the necessary licenses are available.

[@branzo79]

This is great! Question, if publishing a report to the server (that uses this method) must I update new data submissions from the desktop PBI and republish? Or can I now refresh the report from the server?

[@nguyentonhu6710]

I got this error when following the your instruction. Can you help what I should do next? "DataFormat.Error: External table is not in the expected format. Details: 8f2adbeb-625c-4126-ac29-8216e40339ed.XLS"

[@bonifacesoh2255]

Really insteresting tutorial thank you so much!!

[@MuhammadBerki]

Thanks Parker 👍

[@BIElite]

No problem, Muhammad!

[@SaleemAhmad-oh7qh]

Does this method still work? I tried for hours but it gives me error. Also the Pbix file has no data.

[@mirrrvelll5164]

But what if my Forms are not in Excel but directly made in Forms Platform? It is another code and links. Can it be tweaked?

[@poweruserwithcrashlongjohns]

@mirrrvelll5164 when your form is built within the MS Forms platform if it was created as a Group form your excel file will be in the SharePoint tied to the Group. If its not tied to a group you can utilize Automate to write your MS Form submission to a SharePoint list. Then in Power BI you can connect it to your SharePoint list.

[@jasons6721]

I'm unable to authenticate. If I paste the link into the browser, it immediately downloads the file, but from Power BI, it won't let me authenticate.

[@billshipman8051]

Who knew? really nice thank you.

[@BIElite]

For real! No problem.

[@TraceyOsbornHR]

For some reason, the visuals won't refresh, but the data is refreshing. Any ideas?

[@hokki28]

Very useful! Is there a similar approach für Bookings data?

[@AujzAL]

You’re amazing!! Thanks for sharing

[@lenzypetty9371]

Great video....thanks so much

[@yukithejapanese]

Great tip!

[@jimihieu]

Nice one! Can you do same for MS List?

[@BIElite]

Hmm, I’ve never used MS Lists before. Looks like they have a legitimate API. I’ll look into a video on this topic.

[@andrekroker420]

Awesome!

[@BIElite]

Agreed!

[@sanjayfenderUtube]

It's not getting connected

[@chaoweizhong8350]

Wonderful！！

[@BIElite]

For sure!

[@hobbyhuman9499]

Amazing.

[@rkrishang]

Amazing

[@satishpatilkulkarni9434]

Getting credential error

[@SanataniAryavrat]

This is awesome video. Thank you. Just one suggestion, could you also make a video on how to analyze survey data and create some awesome dashboard presentation?

[@BIElite]

Hey Manoj, glad you liked it. Thanks for the video recommendation, I’ll look into it!

[@jonathanbenitez6772]

Worked like a charm for about a month but now mine is not updating due to an authentication error, it looks like it's something with the token needing credentials(?) Anyone know of a fix?

[@tnsparks]

look below at my comments

[@barryc7443]

@@tnsparks Cant find you comments anywhere are they still valid

[@MV-us8lw]

Could it be this no longer works? If so, anyone knows another way?

[@lukenoidss]

not working

[@jlhayes24]

Please Acknowledge the problem!!! Is there anything that can be done? Is there anyone looking for a solution? If there is anyone that has fixed issue please share.

[@tnsparks]

I found a workaround method, its not a fix to this but a different way to enter it. The form has to be saved to a group in Forms first. Then open the responses with the excel cloud icon. Once open then file and info and open desktop app. Then file, info and copy path. You can use this link instead in power bi. This has been working for me so far. Hope it helps

[@chukachukwu]

I've implemented a solution using excel, one drive and Powerautomate

[@Blubnuggetto23]

doesn't work anymore

[@DanielMcLellan-m5o]

Unfortunately Power BI doesn't support this type anymore. An update would be great.

[@bulletkip]

goated

[@kvs123100]

Cringe videos have millions of views! This video which solves real world problems has only 10k! No wonder why the world us struggling!

[@lukenoidss]

its useless cause micrsofot forms has not formid link anyomore

[@andreamonico8034]

Awesome!

[@BIElite]

Thanks Andrea!

[@dannileggatt5866]

brilliant!