Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Refreshing data through Onedrive

Im am building a PowerBI report in desktop and then publishing it to the web via a Office 364 Group Workspace. I have serveral data sources with one being Sharepoint onlines and the one other being a...
Need Help
  • jeffshieldsdev's avatar
    jeffshieldsdev
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, I found another articale that showed how to get a different URL that didnt have this and it worked. It is strange the the same URL isnt used.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi - Did you find a solution to this? I'm running into the same issue.  

  • jeffshieldsdev's avatar
    jeffshieldsdev
    Solution Sage
    6 years ago

    The accepted solution didn't work for you?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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