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:

    I've tried different approaches to connect and download a table from its child page:

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




    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("", [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