Error accessing data from Web

[Anonymous]

Hi,

I am trying to fetch data from https://qualysguard.qualys.com . I try connecting via Get data-> Web. Then i passed credential using Basic. I am getting below error. Can anyone help me out here

DataSource.Error: Web.BrowserContents currently supports only anonymous credentials.

 Regards,

Nidhya

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

That error means that the site does not accept connections made with a username and password entered in Power BI through this dialog 

It's saying you must connect to it Anonymously

If the site requires authenticationthen you probably need to pass it in the request headers like this

    api_url = "https://qualysguard.qualys.com/",
    ClientID = "xxxxxxxx",
    Secret = "xxxxxxxx",
    
    EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),
    
    Response  = (Web.Contents(api_url,
    [ 
      Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
      Content=Text.ToBinary("grant_type=client_credentials")
    ]
    )
    )

But that might not be exactly correct because I don't know how the site requires an authenticated connection to be made.

If you can supply further info on exactly how the site expects a connection I can help out some more.  Does the site provide API documentation?

regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[AllisonKennedy]

I'm not sure, as I don't have access to this site, but there are many ways to get data from web, lots of M functions. Try one of these others: https://docs.microsoft.com/en-us/powerquery-m/web-page Or if you post in the Power Query forum you might get some of the gurus there to help out.