Get data from web with login

Not a solution, but a work around. Save the web page to file from your browser, then import the data using web anonymous mode. The URL will look something like this:

file:///C:/temp/yourwebsite.html

Obviously not ideal as the data won't refresh automatically, but hopefully helpful to someone who just wants a piece of static data.

Hello,

I would like to get data from this website

https://products.markit.com/indices/data/Indices.asp?menuID=796

I tried to connect with "basic authentification" but it does not work...

Can someone please help me ?

Thank you in advance.

Has anyone found a solution to this?

Hi edouardhardy

Is there a space in your login or password ? If yes change My Login to "My Login"

Quotes will solve this kind of problem

Else I see that your link is maybe the wrong one as the login page of your website is : 

https://products.markit.com/home/login.jsp

- Quentin

I have the same problem. Even when I typed my pasword and ID in Power BI, I am not able to get data because it seems like i did not log in the data server. 

quentin_vigne could you please point us related person about this issue if you know who s/he is ofc? 

I'm having the same issue..

Same problem here

I have the same problem. Both in PQ in Power BI or in Excel. Please Help

Did anyone find a solution for this? I'm having the same problem

Does anyone has the solution for these?