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?
Solved! Go to Solution.
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.
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.
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.