Forum Discussion
“The parameter is incorrect” error when adding Amazon Athena ODBC DSN to Enterprise Gateway
I finally resolved this error by re‑creating my Athena data source after changing the gateway service to run under the Local System account so it could decrypt the stored credentials. Steps:
On the gateway machine, open services.msc.
Find On‑premises data gateway service (usually PBIEgwService).
In Properties → Log On, switch from NT SERVICE\PBIEgwService to Local System account.
Restart the gateway service.
In Power BI Service → Manage gateways → [Your gateway], remove the broken Athena data source.
Click + New data source, choose Amazon Athena, enter:
DSN = your System DSN name (e.g. AmazonAthena)
Authentication method = Anonymous
Click Create, then Test – you should see “Connection successful.”
Finally, in your workspace dataset Settings → Gateway connection, re‑map to the new Athena source and test again.
After these steps, scheduled refresh works without the “parameter is incorrect” error.
I finally resolved this error by re‑creating my Athena data source after changing the gateway service to run under the Local System account so it could decrypt the stored credentials. Steps:
On the gateway machine, open services.msc.
Find On‑premises data gateway service (usually PBIEgwService).
In Properties → Log On, switch from NT SERVICE\PBIEgwService to Local System account.
Restart the gateway service.
In Power BI Service → Manage gateways → [Your gateway], remove the broken Athena data source.
Click + New data source, choose Amazon Athena, enter:
DSN = your System DSN name (e.g. AmazonAthena)
Authentication method = Anonymous
Click Create, then Test – you should see “Connection successful.”
Finally, in your workspace dataset Settings → Gateway connection, re‑map to the new Athena source and test again.
After these steps, scheduled refresh works without the “parameter is incorrect” error.