Forum Discussion
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...
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.
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.