none
Power Query - Authentication RRS feed

  • Question

  • Hello, 

    I'm trying to connect to a HTML table that I have access to after I log in to this website with my credentials: https://www.2easy.com.br/Bombardier/

    I've tried different approaches to connect and download a table from its child page: https://www.2easy.com.br/Bombardier/ASP/Content/InfGer_AdmitidosDemitidos.asp

    1st. Attempt - I've setup basic authentication and provided my user/password credentials, then I used the following M codes without success

    Web.Page(Binary.Buffer(Web.Contents("https://www.2easy.com.br/Bombardier/ASP/Content/InfGer_AdmitidosDemitidos.asp")))

    and 

    Web.Page(Web.Contents("https://www.2easy.com.br/Bombardier/ASP/Content/InfGer_AdmitidosDemitidos.asp"))

    2nd. Attempt - I've setup anonymous authentication and tried to provide my credentials within the following M code - but with no success too.

    = Web.Page(Web.Contents("https://www.2easy.com.br/Bombardier/ASP/Content/InfGer_AdmitidosDemitidos.asp", [Headers=[Authorization="Basic user:password"]]))

    Do you guys could help me out on how to connect to this website using PowerQuery?

    I'll really appreciate your help.

    Thanks, Daniel

    Friday, May 19, 2017 10:18 PM

Answers