Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

REST API Basic AUTH

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!

2 REPLIES 2
v-cherch-msft
Employee
Employee

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.