Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Power BI unable to detect data catalog in AWS Athena

Steps taken:
1. Connected AWS RDS (relational DB) to AWS Athena

2. Queried data in AWS and confirmed tables exist

3. Connected Power BI to Athena via ODBC data source (screenshot 1)

Screenshot1.PNG

4. Used Power BI to pull data from the created data source (screenshot 2)

Screenshot2.PNG

 

Issue: Power BI detects the incorrect data catalog even though a different catalog was specified in the ODBC data source configuration

Status: New
Comments
v-chuncz-msft
Community Support

@mhe2021 

 

Try the latest version to test it. Besides, you may specify connection string and SQL statement.

Anonymous
Not applicable

You can set the Metadata Retrieval Method to ProxyAPI.

 

pascal75_0-1639683393968.png