Forum Discussion
Refreshing data through Onedrive
You have to strip out the :x/r/ from the middle of the URL and the question mark and everything after from the end and then it'll work.
The accepted solution didn't work for you?
Unfortunately, no it did not. We have both an Oracle data source and OneDrive data source in the data gateway and pbix file. The :x:/r/ was removed from the link as shown below in both the desktop app and the online version. When solely uploading a pbix file with only a OneDrive data source it refreshes/functions perfectly and uses OAUTH2 for the authentication method in one of the screenshots attached. However, when combining a OneDrive data source with an Oracle Datasource I receive the below error message and the OAUTH2 authentication method isn't available. If you're able to assist or point me in the right direction it would be greatly appreciated.
https://-my.sharepoint.com/personal/tony28_michaels_com/Documents/Location%20Reference.xlsx