Hello, In PBI desktop I want to get data from WEB, but the website needs credential, where I have to enter website credential? Thanks

I was able to get a password prompt, but now Im getting "The credentials provided are invalid" although I can type the url, username, and password in a browser and it works great!! No dual auth, basic login screen. Here is how I was abel to get a prompt:"get data" -> webType in URL (https)receive "Unable to connect" message click edit, now you have a "open file as" option select html then click ok and now you have a username and password prompt.

Hello PBI Superusers / Admins, Having same problem "Credentials Provided are Invalid" for HTML Connector to a Website that needs basic authentication. When you provide user credentials on the Browser - Able to access this. Have been searching for a solution for quite some time. And the Frown's not helping in this regard.

It's really disturbing that there has been literally NO support from MS on this subject. If you're going to support basic authentication, it would be really helpful to understand what's happening when Power BI attempts to have a 'conversation' with the designated web site / web page, as well as some guidance on how to get basic authentication to work properly in various scenarios.

I need you help for connecting form based authentication website from POWER BI. I am admin of shopping website, i need to gve credential to get the access to orders and sales data.But the basic authentication in web connector says invalid credentials though i am able login with same in browser. other options say this not supported. Your inputs will be of great help. Thanks,Karthik

I'm not a web wiz and I'm not trying to be a douche, but it probably isn't Microsoft's Power BI Team's job to teach us about how websites authenticate users.

Connect to a website that has credential | Microsoft Fabric Community

28 Replies

jeslincjoy
Advocate I
8 years ago
Hello PBI Superusers / Admins,

Having same problem "Credentials Provided are Invalid" for HTML Connector to a Website that needs basic authentication. When you provide user credentials on the Browser - Able to access this. Have been searching for a solution for quite some time. And the Frown's not helping in this regard.
Greg_Deckler
Community Champion
10 years ago
sarahs - There was a new update for Desktop released yesterday and it includes "fine grained scoping of credentials" for web connector.
https://powerbi.microsoft.com/en-us/blog/power-bi-update-lots-of-new-authoring-features-and-a-new-power-bi-desktop-update/

Perhaps that will solve your issue?
- DQ
  Frequent Visitor
  9 years ago
  I reviewed the new update and It is difficult to determine how to properly configure the autentication setup. For example my URL connection links to a commercial customer compaint management sytem but the url directs you first our company's enterprise login screen and then to the 3rd party website.
pqian
Microsoft Employee
10 years ago
sarahs It really depends on the type of credentials, baisc auth, form auth, OAuth are handled differently. Some Websites have 2 factor auth that we simply can't support. What is the website in query?
- dskarthik
  Frequent Visitor
  9 years ago
  
  I need you help for connecting form based authentication website from POWER BI.
  
  I am admin of shopping website, i need to gve credential to get the access to orders and sales data.
  But the basic authentication in web connector says invalid credentials though i am able login with same in browser.
  other options say this not supported.
  
  Your inputs will be of great help.
  
  Thanks,
  Karthik
  - jcesarvab
    New Member
    9 years ago
    Hello
    Have you found the solution to this?
- pqian
  Microsoft Employee
  10 years ago
  FYI, this post on the PQ forum has some relevant information
  https://social.technet.microsoft.com/Forums/en-US/71a7fc6f-970a-4272-8c7c-3a15dd00d113/power-query-and-secure-websites?forum=powerquery
- sarahs
  Frequent Visitor
  10 years ago
  Thanks pqian,
  I'm going to connect to WhenIWork site and the website just needs once authentication.
  - dskarthik
    Frequent Visitor
    9 years ago
    Did u get any solution for this??
    
    I am also looking for similar task.
    
    I am admin of shopping website, i need to gve credential to get the access to orders and sales data.
    But the basic authentication in web connector says invalid credentials though i am able login with same in browser.
    other options say this not supported.
    
    Your inputs will be of great help.
    
    Thanks,
    Karthik
MeryBen
Regular Visitor
9 years ago
I have the same issue. Any solutions ?
- dskarthik
  Frequent Visitor
  9 years ago
  there is a paid connector to shopify.com. But it is little expensive.
  - deigeb
    New Member
    9 years ago
    Struggeling with the same problem and not finding a proper solution.
    PBI documentation is still outdated, not even mentioning the newly released "advanced" feature.
    
    My situation: I need to access data on a website that requires login credentials first before navigating to the relevant page with the data displayed. So there is this redirect in place as part of the authentification.
    
    Any solution in place?
chethan
Resolver III
9 years ago

sarahs
do some custom setting in Internet explorer, User Authentication & Automatic logon with current username and password enable this it will work
Anonymous
Not applicable
8 years ago
You need to add an "Authorization" header to your web connector via the advanced tab when you enter the url in Power BI. The authorization header accepts the Basic encrypted credentials that are sent when you login to that site in your browser.

I used Fiddler to monitor the web traffic going in and out from my browser to see the Basic encrypted credentials that are used when I log into the website (under the raw tab in Fiddler it will say "Authorization: Basic (your encrypted credentials)". You could probably use some kind of encryptor website that takes your credentials and provides you with the Basic encrypted string, but I didn't think of that when I did this.

Edit: And this is how you can do it without Fiddler, go to https://www.base64encode.org/ and type in your credentials like so:
"username password"
With a : instead of a space no quotes obviously. Hit encode and now you have your Basic encrypted credentials. You can probably write this in M and replace the Authorization header code with a Base64 function in M but my M ain't exactly advanced.

Finally, under HTTP request header parameters in Power BI I chose "Authorization" as the header type and entered in "Basic (encrypted credentials from Fiddler)"

This worked for me.
- SQLArchitect
  Frequent Visitor
  8 years ago
  It's really disturbing that there has been literally NO support from MS on this subject.
  
  If you're going to support basic authentication, it would be really helpful to understand what's happening when Power BI attempts to have a 'conversation' with the designated web site / web page, as well as some guidance on how to get basic authentication to work properly in various scenarios.
  - Anonymous
    Not applicable
    8 years ago
    I'm not a web wiz and I'm not trying to be a douche, but it probably isn't Microsoft's Power BI Team's job to teach us about how websites authenticate users.
- jesspiorier
  Frequent Visitor
  6 years ago
  I realize that this is an older post, but I'm struggling with this same issue. I tired all of the steps provided, without success. Are you able to share some generic/blurred screenshots of your process? (I have my basic encryption key). Thanks.
- SQLArchitect
  Frequent Visitor
  8 years ago
  It's really disturbing that there has been literally NO support from MS on this subject.
  
  If you're going to support basic authentication, it would be really helpful to understand what's happening when Power BI attempts to have a 'conversation' with the designated web site / web page, as well as some guidance on how to get basic authentication to work properly in various scenarios.
Anonymous
Not applicable
8 years ago
You need to add an "Authorization" header to your web connector via the advanced tab when you enter the url in Power BI. The authorization header accepts the Basic encrypted credentials that are sent when you login to that site in your browser.

I used Fiddler to monitor the web traffic going in and out from my browser to see the Basic encrypted credentials that are used when I log into the website (under the raw tab in Fiddler it will say "Authorization: Basic (your encrypted credentials)". You could probably use some kind of encryptor website that takes your credentials and provides you with the Basic encrypted string, but I didn't think of that when I did this.

Finally, under HTTP request header parameters in Power BI I chose "Authorization" as the header type and entered in "Basic (encrypted credentials from Fiddler)"

This worked for me.
negi007
Community Champion
5 years ago
sarahs

If your data is available in any third-party website, then you would need credentials of that website to be able to access the data from powerbi. In my opinion you can use organization account to access the webdata, in cases where data is available in Microsoft cloud/services only.

The available authentication methods for this connector are:

Anonymous: Select this authentication method if the web page doesn't require any credentials.

Windows: Select this authentication method if the web page requires your Windows credentials.

Basic: Select this authentication method if the web page requires a basic user name and password.

Web API: Select this method if the web resource that you’re connecting to uses an API Key for authentication purposes.

Organizational account: Select this authentication method if the web page requires organizational account credentials.

refer to below links for help

https://docs.microsoft.com/en-us/power-query/connectors/web/web

https://docs.microsoft.com/en-us/power-query/connectors/web/web-by-example

https://docs.microsoft.com/en-us/power-query/connectors/web/web-troubleshoot#authenticating-to-arbit...