Connect to a php website with authentication

[Anonymous]

Hello!!!

I am trying to get data from .php website that needs authentication. 

As example, my data is in a webpage like https://powerbi.system/php/report/report.php and the login page is like https://powerbi.system/php/login.php However, the Authentication window in Power BI returns the login page like https://powerbi.system that is not the correct login page and due that I cannot login.

Is there a way to setup the login page and my credentials?

All the webpage above are examples. 

Thanks!!

[Anonymous · Accepted solution]

Hi @Anonymous ,

In fact, you can't direct to use web connect to with login url, power query not support to redirect to another webpage.

In my opinion, you need to contact to support of that web site to get correspond develop resource(login api), then you can use web connector to get data from that api with account and password to get access token to invoke other REST APIs.

Regards,

Xiaoxin Sheng