Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
edouardhardy
Regular Visitor

Get data from web with login

Hello,

I would like to get data from this website : 

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

This website require login and I tried to put my identification information but it does not work.

Does somebody know why ?

Thank you in advance !

 

x0FPEL

 

 

23 REPLIES 23
Tate2000
Regular Visitor

Hi. I have the same problem and in this tutorial Tutorial: Import and analyze data from a webpage - Power BI | Microsoft Docs  it says "Web connections are only established using basic authentication. Web sites requiring authentication may not work properly with the Web connector." 😞

BlueTiger
Helper I
Helper I

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.

Best solution i've found so far 🙂 thanks.

Anonymous
Not applicable

Does anyone has the solution for these?

Karl_1985
New Member

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

heruMonas
Regular Visitor

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

opsus
Regular Visitor

Same problem here

Anonymous
Not applicable

Has anyone found a solution to this?

Hi,

 

So have you found a solution please?

 

Thanks

Anonymous
Not applicable

I'm having the same issue..

cesady
New Member

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? 

quentin_vigne
Solution Sage
Solution Sage

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

Hi quantin_vigne and thank you for your answer

My login is a email address...

I know the login page is 

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

But the data is here :

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

I don't know how to do it

@edouardhardy

 

Did you follow this tutorial step by step ? : https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web

 

- Quentin

Yes but this tutorial does not mention any login step...

@edouardhardy

I've just wanted to be sure you were in the right place

 

On the place box where you have "Sélectionnez le niveau auquel appliquer ces paramètres" 

Did you try the others links in the dropdown list ? 

 

- Quentin

Thank you 🙂

Yes I tried every level of the website but it always blocks...

 

9CoUNW

@edouardhardy

 

I think the problem is that datas and the login page are on two differents pages

Maybe someone with more experience than me will find out

 

- Quentin

Did anyone find a solution to this issue please?

asmgx
Regular Visitor

has anyone find the solution for this issue?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.