Forum Discussion
Web Content - Access Method - WWW-Authenticate header doesn't contain a valid authorization URI
Found a work around for this, which would be hepful and would transition from APIs to Sharepoint-
1. Add the Microsoft form to the "Form Group Name" Forms Group.
This can be done by opening the forms home page, scroll to bottom and click on "All My Forms". On the next page, click on ellipses and choose "Move".( We'll first try to copy the form and responses, and will then see how it goes.)
2. After the form is moved, Open the form again from "All My Forms" Page, and then Open responses in excel, Go to File Menu -> Info-> Copy Path.
3. Change the source in the pbix to the new SharePoint web link.
We tried this with a test form but we're still running into the same authentication issues.
Update - so I got this this method to work via the sharepoint folder connection (I missunderstood the instructions) but it changed the link to the original form which stinks and I haven't tried this yet with the actual survey responses so there may be other challenges to consider. I'm just frustrated by the abrupt nature of the change, lack of acknowledgement by MSFT, and general lack of a BI data connector for Forms, necessistating all these work arounds.
Second update: So Anonymous's solution of moving the form to a group works great (the old forms link automatically redirects so no need to deploy a new URL). you'll have to modify your power query to shift the source from a Web Connect to a SharePoint folder. We had to rebuild our transformation steps but that was pretty straight forward and we didn't run in to any other issues.