Can Connect to Elasticsearch using Edge and Internet Explorer but not Using Power BI

[Kieran]

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

[mwegener]

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

[Kieran]

After further investigtion ...

This issue in my client's environment that they have a proxy server for internet access.

Power BI Desktop does not support proxies...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20393473-support-proxy-authentica...

So this was how I managed to authenticate to Elasticsearch through my browsers but not through Power BI desktop.

I have negociated a work around with my client in that I now have a privilege account which accesses the internet directly and not through a proxy.

However longer term Power BI needs to support proxies.

[v-jiascu-msft]

Hi @Kieran,

I would suggest you contact the administrator of your site. I have browsed this document and found nothing related to authentication.

Did you try the Anonymous authentication method? It worked in my test. Please refer to the snapshot below.

Is it an on-premise server or a cloud service?

Best Regards,
Dale