Forum Discussion
Power BI - How to hide the API token from dataset?
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!
2 Replies
Web.Contents - PowerQuery M | Microsoft Learn
Usually, key value isn't explicitly put in query, just the name of the API key.
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-authentication.htm 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?
