Forum Discussion

directvman67's avatar
directvman67
Frequent Visitor
9 months ago

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...
Need Help
Jai-Rathinavel's avatar
Jai-Rathinavel
Super User
9 months ago

directvman67 Please disable the privacy level setting to resolve the above issue. 


Thanks,
Jai

  • directvman67's avatar
    directvman67
    Frequent Visitor
    9 months ago

    Sorry, as I mentioned, I tried that and it did NOT solve the issue. 😥

  • directvman67's avatar
    directvman67
    Frequent Visitor
    9 months ago

      • directvman67's avatar
        directvman67
        Frequent Visitor
        9 months ago

        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"