Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Web.Contents - PowerQuery M | Microsoft Learn
Usually, key value isn't explicitly put in query, just the name of the API key.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
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?