Share via

Excel Get Data>From Web correct link

Anonymous
2020-02-26T01:19:36+00:00

Hello,

Wondering if anyone knows the correct procedure to connect to a workbook saved to OneDrive. I found a tutorial for power BI that suggest to go to File>Info>Copy path which is located near the top 

Link is similar to this https://d.docs.live.net/90-Some-ID-d2d/FolderName/FileName.xlsx

When I try to add it from the Data tab > From Web

I get 5 options:

Anonymous, Windows, Basic, Web API, Organizational Account. 

Since I have office 365, I read that I should use Organizational Acc. However I get the following

The WWW-Authenticate header doesn't contain a valid authorization URL. Header value: 'Bearer realm="OneDriveAPI", Error="invalid_token", error_description="malformed auth token"

I google skills are failing me on this one. Can someone provide info on how to get the proper link

Microsoft 365 and Office | OneDrive | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-26T19:46:52+00:00

    Hi JGExcel,

    Thanks for posting your concern in the Community.

    Working with files in OneDrive should not be a hassle.

    However, here in the Community Forum, OneDrive has already reached it’s end of support. You may see this article for more information.

    To get the best assistance, we strongly recommend submitting your concern to our OneDrive Email support. Please follow these steps:  Sign in to onedrive.com using any browser.  Click the ? icon (Help icon) on the top banner of the page.  Select Email OneDrive Support, submit your concern and then follow the prompts to request support.

    You can also visit OneDrive Help Center for additional help.

    To notify us and have us get back to you, simply reply to this post.

    0 comments