Showing results for 
Search instead for 
Did you mean: 
antohos Frequent Visitor
Frequent Visitor

Re: Enterprise Gateway with ODBC

Hi Everyone,


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:





nassaf Frequent Visitor
Frequent Visitor

Re: Enterprise Gateway with ODBC

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."

sirros_iot Member

Re: Enterprise Gateway with ODBC

Try to download On-premises data gateway (personal mode). It worked for me.