Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Getting data from OneDrive

Hello Communiy,

I am having an embarrasingly hard time pulling a file from OneDrive into PBI.

Most stuff I find tell me to use the "OneDrive for Business connector" which appears to have been removed.
Next way I found tells me to go to OneDrive -> The file -> Details -> Copy Path but they appear to have removed the 'Copy path button' as seen in this screenshot:


Third way I found is from Microsoft's documentation: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
This article is recent (October '22) but it tells me to use the 'Copy path' button that I cannot find. It also tells me to use the web connector but the web connector only supports authentication method: anonymous which would then require me to make the file publicly available so it doesnt just get stuck on the log in screen.

There must be something I am missing? I am surprised the integration between Microsofts own cloud storage service and BI tool isn't just a two click process. There must also be a way to retrieve the file while still  keeping a minimum of privacy?
I can create a shareable link but am not satisfied making it available to everyone who can find the link.

Any help would be much appreciated, I simply do not understand how to get a file from OneDrive into PBI

8 Replies

  • Anonymous , On web choose open in Open in dektop app

     

    In desktop you will have the option copy path

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your reply.

      Using the steps you provided I was able to get a path for the file but I am experiencing a new error:


      I have tried multiple auth methods but cannot seem to get it to work.
      Which auth method and privacy level should be correct?

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion

        You need to delete the ?web=1 bit at the end of the path

  • Anonymous's avatar
    Anonymous
    Not applicable

    I am on a personal version of OneDrive and I believe this feature might be disabled for the personal one. Can anyone corfirm this?

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion

      That may well be the issue. I seem to remember reading that the OneDrive connections work only with a "corporate" office license