Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

mhe2021

Power BI unable to detect data catalog in AWS Athena

Submitted by on ‎08-23-2021 10:30 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎08-24-2021 03:02 AM

@mhe2021 

 

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

Anonymous
Not applicable
‎12-06-2021 02:32 AM

You can set the Metadata Retrieval Method to ProxyAPI.

 

pascal75_0-1639683393968.png

 

Idea Statuses