Get data from web with credentials

Question

I want to extract data from the web, which requires an authentication credential and when I try to write the credentials, It doesn't&nbsp;allow me (it's not active to write a credential).&nbsp;

usman · Answer

I'm getting this error after doing what you said.DataSource.Error: Web.BrowserContents currently supports only anonymous credentials.
Details:
    DataSourceKind=Web
    DataSourcePath=https://simplywall.st/login

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
First, go to Edit queries-&gt;data source setting, clear or edit this data source credential, select "Basic" from the window and type your username and password.
Then selecting the&nbsp;Extract table using examples&nbsp;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-by-example
&nbsp;
Best Regards,Lin

anonymous · Answer

Hello PBI community&nbsp;I keep getting this same error in PowerBI on the one hand, and in Excel on the other hand. I would prefer to avoid Excel and VBA as I need the feature 'Add table by example' that is only available in PBI to be able to extract the data I need. Is this still unsolved in PowerBI?&nbsp;Thank you for your help.&nbsp;&nbsp;See parallel thread on this topic:&nbsp;https://community.powerbi.com/t5/Power-Query/Not-able-to-import-data-from-webapge-with-valid-credentials/td-p/671479

anonymous · Answer

v-lili6-msft&nbsp;Thank you for your reply!I keep getting an error message " The credentials provided are invalid "&nbsp;

pauldbrown · Answer

I was trying to do the same on a website with credentials to no avail. I eventually gave up trying with Power BI. I succeeded using Excel and VBA (I haven't a clue about VBA, but Google is your friend for these things...).

It is a real pain, since it involves manually updating the excel file, but...

I hope there is a simple way to do this in PBI.

Forum Discussion

Get data from web with credentials

8 Replies

Related content

Data Source Credentials

Data Source Credentials

Power BI Data Source credentials

Data Source Credentials Password Change

Data source credentials missing