


Has anyone solved it?Īctually I figured out what was happening, and the solution is pretty dumb.īasically you can't have any spaces (%20) in the URL string to your file on One Drive. However if you notice, OneDrive will naturally save to a library called "My Documents". The way to get around this is to create a sharepoint group (again with no spaces in the group name). Then create a document library in that group's website (no spaces in this name). Once you create the doc library, upload your file there (again file name no spaces). Modify it to make sure you have a nicely formed URL something like: Once its uploaded, then get a copy of the URL to the file from the context menu. Once you have that, you should be able to get the organizational popup to come up just fine. Seems like Microsoft should put OneDrive as a source and fix this issue, seems buggy to me. Users are always going to have spreadsheets on OneDrive that they want to mash up in a data flow.
