Getting data from OneDrive

[Anonymous]

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

[Anonymous]

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]

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

[amitchandak]

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

In desktop you will have the option copy path

[Anonymous]

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]

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

[Anonymous]

Thank you for your reply.

My link looks like this (Anonymized):
"https://d.docs.live.net/2964b1545d06e217/folder1/folder2/External%20data/filename.xlsx"

[PaulDBrown]

You should use the web connector

[Anonymous]

I have tried with the web connector which results in the error I previousl shared.

As far as I know the web connector only supports auth method anon but I have tried all of them now with the same result unfortuneately