Connecting to website with authentication

[Kolumam]

Hi

I have been trying to connect to a website with authentication. I chose the option basic but it says credentials are invalid. This is so frustrating as this feature was introduced long back and still this is not working. Any alternative method?

Thanks

[v-juanli-msft]

Hi @Kolumam

Please confirm which type of autnentication you need to log in this webpage, then select the correct type of autnentication in power bi desktop.

Best Regards

Maggie

[Kolumam]

This is the website.

https://www.zevercloud.com/login

Create a new account in the website and can you check if you're able to export the data?

Thanks

[v-juanli-msft]

Hi @Kolumam

Paste this url in the box (Get data->Web(Basic)), then select "Anymous", i finally get this page.

Best Regards

maggie

[Kolumam]

Hi Maggie,

I get the same page as yours but that is not what I want. I want to enter credentials to see my data.

[MitchB]

Is there any solution to this yet? I'm having the same issue

[v-juanli-msft]

Hi @Kolumam

First, go to Edit queries->data source setting, clear or edit this data source credential, select "Basic" from the window and type your username and password.

Then selecting the Extract table using examples presents an interactive window where you can preview the content of the Web page, and enter sample values of the data you would like to extract.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example#using-get-data-from-web-...

Best Regards

Maggie