Power BI - How to hide the API token from dataset?

[dhanu3]

Hi,

My dataset query in the advanced editor window looks like the following

let

iterations = 20,
  url= "url",
   FnGetOnePage = 
   (url) as record =>
let
 
 Response = Json.Document(Web.Contents(
     "https://client.product.com",
    [
         RelativePath = url, 
         Headers = [Authorization="bearer mytoken"]
       ]
   )),

and I want to hide mytoken from this dataset , how can I do it?

Thanks!

[ThxAlot]

Web.Contents - PowerQuery M | Microsoft Learn

Usually, key value isn't explicitly put in query, just the name of the API key.

[dhanu3]

Hi @ThxAlot for the response but Sorry, I don't get what you mean. , this product (loggly) has an API token generator https://documentation.solarwinds.com/en/success_center/loggly/content/admin/token-based-api-authenti... only, so by adding 

[Authorization="bearer mytoken"

I was able to pull the data from the product, but what I want is to hide this mytoken .

Any suggestions to hide this token in the query window? or different ways to do the data source connection?