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.
Assuming 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.
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