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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I found another work around.

 

- Open the Form data in excel desktop

- Then click on Info and copy URL

- To test copy the link and Power query (excel or Power BI) , then connect data to web and log in. 

- To refresh your existing report, copy the link open Power BI - Power query , navigate to the source and update the source link eg 

 

Excel.Workbook(Web.Contents("insert link"), null, true) 

and then you can log in again and your report should be back to normal