Forum Discussion
Gateway refresh for an AWS Athena datasource
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.
However, I'm able to refresh the report in my Power BI Desktop.
Could you please advise me on this?
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.
2 Replies
- lbendlin
Super User
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?
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.
