Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI to connect with AWS ElasticSearch API

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

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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