Forum Discussion
Excel DataSource
I tried this several time earlier, but as you listed it I thought I'd try one more time. This is the solution, but I kept getting a Status Code 400 error. In SharePoint on-line I was clicking the elipse and using the copy link option.
To troubleshoot the 400 error I pasted the link in Notepad and then cleaned it up. The copied url added an extra :x/:r . After removing these items I then redeployed and was able to get the credentials to work. I was given the OAuth option and Orginizational Level.
I've since created a flow to process the dataset anytime the spreadsheet is updated.
I appreciate everyone that replied to my issue.
I tried this several time earlier, but as you listed it I thought I'd try one more time. This is the solution, but I kept getting a Status Code 400 error. In SharePoint on-line I was clicking the elipse and using the copy link option.
To troubleshoot the 400 error I pasted the link in Notepad and then cleaned it up. The copied url added an extra :x/:r . After removing these items I then redeployed and was able to get the credentials to work. I was given the OAuth option and Orginizational Level.
I've since created a flow to process the dataset anytime the spreadsheet is updated.
I appreciate everyone that replied to my issue.
Super UserYes, copy and paste of the url will cause that error and this approach of copy paste causing error is there for many years.
Other way I do is
From SharePoint online, open the file in Excel desktop, and in Excel after the file opened > File (menu) > Info, copy path, paste in notepad, copy the url portion that we need.
Like removing the words "?web=1" at the end