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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Kudoed Authors