Lookup for data in Onedrive excel file

Martin 1 Reputation point
2022-10-25T17:36:26.897+00:00

Hi,

I use Office Professional Pro Plus 2021 Version 2209.
I've been convinced, that it is possible to lookup data in an excel file on onedrive to access data in a powerquery without syncing it to a local hdd, hence without using a local path instead of the cloud data directly.
There are a few instructions to add the files with adding them by GET AND TRANSFORM DATA >> FROM WEB

There are relevant files on OneDrive which I can access with a web path like "https://onedrive.live.com/**********=file%2cxlsx"
respectively a path got from the desktop app app like "https://d.docs.live.net/********.xlsx".

I tried to lookup data from an excel file on onedrive via both paths, but neither one allow me actually to access it.

As autorization method I've been told to use "Windows", see below (Screenshots with German version)
254041-image.png

But with the link from the desktop app I get a message "connection is not possible" as you can see below

253929-image.png

If I try to use the web-Link, it obviously tries to feed html content which I can't use, see below.

253920-image.png

A solution for that is highly appreciated. Thanks in advance.

Cheers,
Martin

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,192 questions
{count} votes