I am making a content pack for Power BI.
I am using REST API, but I have to use basic AUTH.
I need to pass the username and the password as parameters for the API call, not just a plain txt. So anyone can put in their own username and password and connect their own data to that content pack.
let actualUrl = "https://XXX/api/c/entities?type=TEM", options = [Headers =[#"Content-type"="application/json", #"Authorization"="Basic <User : Password>"]], result = Web.Contents(actualUrl, options) in result
How can I pass that user and password as parameters into the code? Or, is there any workaround?
Thanks in advance!
You may have a look at below post. If it is not your case, you may submit a support ticket.
I have already seen those links, but I have to use M Formula Language.
I think I have found a partial solution:
let Source = let data = [ path= "/code", recursive=false, include_media_info=false, include_deleted=false, include_has_explicit_shared_members=false ], actualUrl = (InstanceURL) & "/api/c/entities?type=STR", Headers =[ #"User"=(Username), #"Pass"=(Password), #"Content-type"="application/json" ], result = Web.Contents(actualUrl, [Content=Json.FromValue(data),Headers=Headers]) in result in Source
It does log in if I do not add this piece of code:
But from the moment I add that piece of code it doesn't log in.
Note: InstanceURL, Username and Password are parameters.
Thanks for your time!