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.
Super UserAssuming it is sharepoint online, check these and see if it fixes
1. Power BI Service -> Workspace -> Data flow -> right click -> Settings
2. Data source credentials > SharePoint > Edit credentials and see if you can connect
3. Once you are able to connect, go back to data flow and refresh
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.
- sevenhills
Yes, 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 isFrom 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