I am having a problem to create a link in Power Query to a OneDrive file that is shared with me.
Excel Power Query does not allow me to link to a file through a https:// address.

I can link to a file that is synced to the OneDrive on my computer, but I can't get the link working to the online file through an URL.
Please advise how to get this done; I can't find anything on the Microsoft websites (user groups, knowledgebase etc.)

HELP!!!