How to copy OneDrive file path in order to connect to Power Query

[Skip2MiLu]

I want to connect a file from OneDrive as a data source in Power Query.

I understand that the best way to do this, is to copy the OneDrive file path and then paste the link into New Source>Other Sources>Web (see reference pictures below).

However, I do not see the same "Copy File Path" icon option in Onedrive that I see as an option in Sharepoint (See reference pictures below).

Can anyone direct me on how I go about adding a OneDrive file or folder as a data source with Onedrive?

 

[Kerryx]

Get data from OneDrive Personal files with Power Query

 

[Candyman8019]

To reference onedrive you'll need to use the path: Sign in to your Microsoft account{whatever the CID value is in your OneDrive}/

 

[Candyman8019]

https:// d.docs.live.net/{whatever the CID value is in your onedrive}

FYI, You'll need to remove the spaces after the //

 

[Skip2MiLu]

Get data from OneDrive Personal files with Power Query

This is initially worked, but now I getting this error. Any help from anyone.

 

[Kerryx]

A quick google says it could be due to active filters on the source file or the presence of a pivot table on the source file