Forum Discussion
directvman67
9 months agoFrequent Visitor
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 dashbo...
Jai-Rathinavel
9 months agoSuper User
directvman67
9 months agoFrequent Visitor
- lbendlin9 months agoSuper User
- directvman679 months agoFrequent Visitor
Thank you for this link. When I first read the article, it sounded exactly like the issue I was experiencing but, sadly, when I tried their solution, it gave me the same error. 😥 Here are the 2 queries I tried following the instructions in the article (where UPS API Site = https://onlinetools.ups.com😞
//Query Called Solution let Source = Excel.Workbook(Web.Contents("https://SHAREPOINT ADDRESS/Sample%20UPS%20Data.xlsx"), null, true), Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data] in Sheet1_Sheet//Second query referencing the first query called Solution let Source = Solution, #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Added Custom" = Table.AddColumn(#"Promoted Headers", "Custom", each let Local_Access_Token = ACCESS_TOKEN, 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) in #"Added Custom"- lbendlin9 months agoSuper User
That probably means they closed that loophole. Have you considered using Power Automate instead to collect the tracking status?
Note that you still use the web connector. Unrelated, but something you'll want to correct.