How to get data from password protected website

[Anonymous]

Hi, Im wondering if there is any simple way to get data using Power Query from a secure website. There is a table which I would like to access but I need to first login using creditials to access it. Is there anyway to do this?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please refer to this case.

https://community.powerbi.com/t5/Desktop/How-to-read-data-from-password-protected-website/td-p/399068

[mimi]

The solution does not help me in my case. You simply explained go to advanced editor. then what do i do after that?

[Anonymous]

The solution did not work for me either. I also need to get data from a website that requires me to log-in first.

Get Data -> "From Web" function does not get to the source as the web site is protected with log-in credentials. Is there anyway for query to log-in to website by itself?

[Anonymous]

Hi,

Did you find solution to this problem?