REST API Basic AUTH

[Anonymous]

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!

[v-cherch-msft]

Hi @Anonymous

You may have a look at below post. If it is not your case, you may submit a support ticket.

https://powerbi.microsoft.com/en-us/support/

https://community.powerbi.com/t5/Report-Server/Power-BI-REST-API-authentication/td-p/295470

Regards,

Cheriee

[Anonymous]

Hello v-cherch-msft, 

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:

& "/api/c/entities?type=STR"

 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!