cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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:

 

C:\Users\PBIEgwService\.aws

 

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:

 

[YourIAMUser]

aws_access_key_id=AKIAIOSFODNN7EXAMPLE

aws_secret_access_key=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY

nassaf Frequent Visitor
Frequent Visitor

Re: Enterprise Gateway with ODBC

I'm getting the same error, did you figure this out?

 

Error:

 

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

Highlighted
sirros_iot Member
Member

Re: Enterprise Gateway with ODBC

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