Gateway refresh for an AWS Athena datasource

[Anonymous]

I have configured a gateway to connect to an AWS Athena datasource and the Authentication type is "Anonymous". I have setup the gateway for one of my report.

When I refresh the dataset I'm encourted with the below error.

ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 100, HTTP Response Code: 404, Error Message: Failed to parse error payload [Execution ID:xxxxxxxxx]

However, I'm able to refresh the report in my Power BI Desktop.

Could you please advise me on this?

[Anonymous · Accepted solution]

Hi @Anonymous 

If you want refresh the dataset in Service ,you need configure gateway and datasource in Service .

(1)You need to install a standard gateway not a personal gateway .To install and configure gateway can refer to the link below .

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app

(2)After configuring gateway , you need to add datasource in Service . Please refer to the link below for specific operations.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

The link below is to introduce how to add ODBC data source in Service , you can refer to it .

https://rukiatu.com/refreshing-odbc-datasource-from-power-bi-service/

(3)When you finish configuring gateway and datasource in Service ,you can set scheduled refresh in Dataset settings .Specific operations can refer to the following link .

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Is this a personal or a standard/enterprise gateway? If the latter, is that gateway located in AWS? Have you confirmed that you can reach the AWS data source from all gateway cluster members?