I was trying to set up a Data Source in Power BI Service with AWS Athena via ODBC data source. And was finally successful.
It's very important that Power BI Gateway is running via user PBIEgwService
For this reason, to make AWS authentication (and data source creation) work, you need to add IAM credentials in the folder for this user:
you will have to create a folder ".aws"
Note, that in order to create such a folder, you should actually try to create a folder ".aws." - windows will cut off the last dot and you will receive a folder ".aws"
Then, in this folder, you will need to create a file with AWS IAM Credentials. The name of the file should be "credentials" with no extension.
The contents of the file should be:
I'm getting the same error, did you figure this out?
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."