Isssue Adding Web.Content Column to Web Data

I am hoping someone will read this and have a solution.  I will try to keep my post as brief as possible, but also with enough detail to understand the current situation.

• I have a PowerBI dashboard that has, as one of its data sources, a table with a column called UPS Tracking Number. 
  • This table is read from a tab of an Excel file on a SharePoint site.
  • As such, this table is loaded using a Web Data Source.
  • The table is read using Organizational Account for the credentials (M365) and a Privacy Level of Organizational (although, as I will mention below in what I have tried, I have used other settings on the Privacy to resolve my issue.).
• I want to use the UPS APIs to load the tracking details for each UPS Tracking Number in to this table.
  • I tried defining functions that used the PowerQuery API calls and then adding columns to the aforementioned table  using the Invoke Custom Function, but this led to errors when I published about not being able to refresh dynamic dynamic data sources in the Power BI service. 😥
• So, after much time and effort scouring the internet, I found another solution that avoided using Functions: that is, to add a column to the aforementioned table using Web.Contents in PowerQuery. 😊
  • So, I put together the PowerQuery shown in the code below.  I set the Credentials for onlinetools.ups.com to Anonymous (the only option that works) and the Privacy Level to Organization (to match that of the aforementioned table).
  • This added column works perfectly fine when used in the PowerBI Desktop application. 😁
  • However, when I publish the dashboard to the PowerBI Service and try to refresh it, I get the error shown in the image below. 😥
• So, here is what I have tried so far...
  • If I use the code below in a stand-alone query (enter it via the Advanced Editor) and publish the dashboard, there are no errors with the refresh. 😊
  • I have tried aligning all the Privacy to the same value, as well as setting the global Privacy to "Always Ignore Privacy Level settings"...but to no avail. 😥
  • I tried replacing the call to another query (AccessTokenQuery) with a hard coded Bearer Token, but still nothing. 😥
  • I tried replacing the dynamic use of [Ups Tracking Number] with a hard-coded UPS Tracking Number, but that failed too.

let

Local_Access_Token = AccessTokenQuery,

    response = Web.Contents(#"UPS API Site", [
        
RelativePath = "api/track/v1/details/" & [Ups Tracking Number] & "?locale=en_US&returnSignature=false&returnMilestones=false&returnPOD=false",        
        
Headers=[Authorization="Bearer " & Local_Access_Token, transId="1", transactionsrc="PowerBI UPS Tracker"]]),
jsonResponse = Json.Document(response)

in
jsonResponse

Does anyone have any idea what I am doing wrong?  Any guidance is greatly appreciated!