cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jwillis07
Frequent Visitor

Call API using Basic Auth + 2FA

Good afternoon all, looking to verfiy I've not done something wrong.


I'm trying to access the Pulseway RMM API that the documentation states: "uses Basic Authentication which requires an authorization header with the username and password in the username:password format encoded as Base64."

 

I've done this but I'm getting a "we couldn't authenticate with the credentials provided. Please try again." error message.

 

When I log in to Pulseway RMM web portal, my organisation requires 2FA in the form of using the Microsoft Authenticator app to generate a one-time 6-digit code - Am I right in thinking this is why I'm getting the failure to authenticate.

 

After looking around this forum, and the net as a whole, I found a post on this forum by @luiTre that said:

y7nh5s7qq5b71.png

So I've tried updating my Base64 encoded credentials to be username:passcode:password but this doesn't work either. I've tried it using an external encoder like base64encode.org, and I've tried handling the encoding directly in Power Query.

 

Does anyone have any experience of calling an API that requires Basic Auth + 2FA?

 

My code:

 

 

let

    URL             =   "https://api.pulseway.com/",
    Path            =   "v2/systems",
    
    Username        =   "username",
    OneTimePasscode =   "123456",
    Password        =   "password",
    
        Credentials     =   Username & ":" & Passcode & ":" & Password,

            Binary = Text.ToBinary(Credentials),
            Base64 = Binary.ToText(Binary, BinaryEncoding.Base64),

    Source = Json.Document(Web.Contents(URL,
            
            [ RelativePath = Path, 
              Headers = [ Authorization = "Basic " & Base64 ]]))

in

    Source

 

1 REPLY 1
v-kelly-msft
Community Support
Community Support

Hi  @jwillis07 ,

 

You need to ask admin to first enable multi-factor authentication for you ,check the reference below:

https://dataap.org/blog/2017/05/11/multi-factor-authentication-for-power-bi-o365/

For basic auth,check below thread:

https://community.powerbi.com/t5/Desktop/Power-query-to-connect-REST-API-with-basic-authentication-i...

 

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors