Power BI to connect with AWS ElasticSearch API

[Anonymous]

We are trying to consume the data into Power BI from AWS ElasticSearch API; Where the authentication method for this API is AWS SIgnature; 

Steps followed;

1. Get data -> Web

2. Given URL, then in Advanced tab filled in Authorization Header with value as AWS sign of available access Key & Secret Key; 

Facing "Access to the resource is forbidden" error; 

Seeking experts advise to proceed; How to successfully connect with AWS ES API from Power BI.  #API #PowerBI #AWS #EsAPI

[Anonymous]

Hi @Anonymous,

I'd like to suggest you send authorization tokens in request header instead of direct use them with connectors.  Please take a look at the following link to know how to use web connector with rest api and authorizations:

Pull data from a REST API Authentication 

Working with Web Services in Power Query 
Regards,

Xiaoxin Sheng

[Anonymous]

Thanks for the reply; Outstanding problem here is authentication method; How to deal with this AWS SIgnature method of authentication from power BI ? 

[Anonymous]

Hi @Anonymous,

If you use the method that I mentioned above, you can choose 'anonymous' authorization mode and do credentials processing in the m query codes.

Regards,

Xiaoxin Sheng