Forum Discussion

timowille's avatar
timowille
New Member
9 years ago

Web Content - Access Method - WWW-Authenticate header doesn't contain a valid authorization URI

Hi,   i'm trying to connect to a custom REST service hosted on an azure app service that is configured to authenticate against Azure Active Directory. The authentication is working fine, when i ope...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

MaryF's avatar
MaryF
Advocate II
4 years ago

Many thanks Pranay, that worked for me.

For others, I've created a  more detailed Step-bystep guide. Note this is for connecting to Forms and assumes you have SharePoint online:

  1. Go to SharePoint and create a site, I called mine My Forms
  2. Go back to Forms scroll to the bottom of the page, click on All My Forms on right hand side
  3. On the form you need you notice an ellipsis (…) at bottom right, click on move to Group
  4. You should see your recently created site, select it and the form will move to that area
  5. Go back to your Forms landing page and you'll see your form, now when you click on it & go to responses choose Open in Excel
  6. From Excel online, go to File | Info | Open in Desktop App - this will download a copy.
  7. From the copy go to File | Info | Copy Path E.g., https://mysharepoint.sharepoint.com/sites/MyForms/Shared%20Documents/NameOfForm.xlsx?web=1
  8. Now in Power BI create a new query, this time from Web and paste in the content from your clipboard | IMPORTANT Remove the ?web=1 part
  9. You may need to sign in again, but this time you should see the content of your form, which will go on to include any new responses.
  • LPE's avatar
    LPE
    New Member
    4 years ago

    Hello MaryF,

     

    Thank you for this super clear guide. I tried it out and do not receive the same connection error but I dont see the values in the table anymore. Did I miss something in the URL content that would allow me to get the content of the forms?

     

    Thanks for your help 🙂

     

    • MaryF's avatar
      MaryF
      Advocate II
      4 years ago

      Hi there LPE

      When you download the workbook (as per step 6) was there data in that file? Also did you remove the ?web=1 from the end of the URL? If yes to both, then I can't see why you don't see it via Power BI. Sorry I can't be of more help.
      Mary

      • LPE's avatar
        LPE
        New Member
        4 years ago

        Hello Mary,

         

        Thank you for your answer! I missed a step, but now it works perfectly!

        Thanks for your precious input!

         

        Ludmilla