Forum Discussion

Alirezam's avatar
Alirezam
Helper V
5 years ago
Solved

Get data from a onedrive link

Here we go, I have a one-drive link, not protected by a password and easily accessible from any browser. Here is the link, nothing is confidential!   https://1drv.ms/x/s!Al3r7IU8GY3ygYhXvI3SWsGIFP-...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Don't @Alirezam,

    You can see the Use OneDrive for Business links in Power BI Desktop, which might be useful for resolving the issue.

    I can't provide you with a screenshot of the connection successfully to your one-drive link because I don't have edit permission for the link you provided, which means I can't get the route.

    15.png

    This is an example of mine.

    1.Select an Excel file and open it in the application.

    16.png

    2.Select Copy path to clipboard.

    17.png

    3.In Power BI Desktop, select Get data from the web and paste the path,move the ?web-1 string to the end of the link so that Power BI Desktop can successfully navigate to the file, and then select OK.

    18.png

    4.If Power BI Desktop prompts you for credentials, choose Windows (for on-premises SharePoint sites) or Organizational Account (for Microsoft 365 or OneDrive for Business sites).

    odb-links_06.png

    5.Finally, the connection is succumbed.

    19.png

    Best regards

    Stephen Tao

    If this post helps,then consider Accepting it as the solution to help other members find it faster.