This is a question / solution for anyone having issues using the method described here
power-query-cant-get-data-from-a-shared-onedrive-excel-file
I came accross a loading error due to a "/" in the url. I understand very little about power query and originally used the script provided by @Zheng Dai. The script does not handle the requirements to replace the "=", "/", "+" characters (see API ->shares_get ). I hope to this saves someone like me a bit of time.
The following script will will handle the characters
let
sharingUrl = "<YOUR URL HERE>",
base64Value = Binary.ToText(Text.ToBinary(sharingUrl, TextEncoding.Utf8), BinaryEncoding.Base64),
encodedUrl = "https://api.onedrive.com/v1.0/shares/u!" & Text.Remove(Text.Replace(Text.Replace(base64Value,"/","_"),"+","-"),"=") & "/root/content",
Source = Excel.Workbook(Web.Contents(encodedUrl), null, true)
in
Source
ADDITIONALLY
if anyone knows a better method to import a table from another workbook, please post it here or make a new post and tag me in it.