cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allan77R2V1 Regular Visitor
Regular Visitor

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 Excel file on OneDrive for Business.

 

I am attempting to configure the Schedule Refresh within the Web and sharepoint works fine as it provides OAuth2 option to authenticate. However, when I try to do the same for OneDrive the OAuth2 option is not listed and it fails to connect(See Image below). None of the authentication options listed seem to work. Any suggestion on how to make this work?

 

2018-12-31 12_28_30-Microsoft Edge.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: 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.

5 REPLIES 5
nirvana_moksh Established Member
Established Member

Re: Refreshing data through Onedrive

Can you confirm the link of the Excel hosted on OneDrive is the actual link to OneDrive file and not a link to your local drive instead? It should show OAuth2 option if the file in question is hosted on OneDrive.

Community Support Team
Community Support Team

Re: Refreshing data through Onedrive

Hi @Allan77R2V1,

 

Please check whether the Onedrive you connected to is online or On-premise. Which type of Gateway did you use? On-Premises gateway or Personal gateway? Please test with a different one.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: 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.

Highlighted
Allan77R2V1 Regular Visitor
Regular Visitor

Re: Refreshing data through Onedrive

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.

Re: Refreshing data through Onedrive

I think the URL with the extra characters will open in a web view (if the file is an Excel file, it'll open in the Excel web app), but the URL without the extra characters is a direct link to the file itself.