Forum Discussion
Advocate IICan Connect to Elasticsearch using Edge and Internet Explorer but not Using Power BI
Hi,
I am able to successfully connect to a data feed using ...
Myurl.com/_stats
UserName: MyUserName
Password: MyPassword
Whilst using Internet Explorer or Edge.
However within Power BI Desktop when I try and make the same connection using the following selections ...
1) Select "Get Data",
2) Select "Other",
3) Select "Web",
4) Url set to Myurl.com/_stats
5) Select Authentication type "Basic"
6)
UserName: MyUserName
Password: MyPassword
I then receive the error message "We couldn't authenticate with the credentials provided. Please try again."
Can anyone help please ?
Kind Regards,
Kieran
5 Replies
- mwegener
Most Valuable Professional
Hi,
maybe the site use authentication with oAuth 2.0.
This blog post describe a connection to twitter with oAuth2.0
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
- Kieran
To use oAuth2.0 I believe you may need to make changes in the configurations to the data source in my scenario. For example provision of a key / token. So to give you more background I am attempting to connect to Elasticsearch by following the link ...
https://blog.sixeyed.com/querying-elasticsearch-with-powerbi/
I have no means of changing the configuration of the Elasticsearch data source I am querying, just the connection in Power BI / Power Query.
I estimate that my most beneficial course of research is attempting to find why my credentials work in the browser but they don't work within Basic authentication within Power BI as stated in my initial question.
- mwegener
Hi Kieran
maybe you can use the Edge DevTools to see, how the authentication is send thru the request.
https://docs.microsoft.com/en-us/microsoft-edge/devtools-guide/network
