"The table has no visible columns and cannot be queried" Connect to AWS Athena

[Lluvia]

Hello Power BI Expert,

I am setting up ODBC to connect the Power BI desktop with AWS Athena.

I tested the connection in ODBC, it was successful.

When I use Amazon Athena connector on the Power BI desktop, it pops up the database and tables, but when I preview or transform the data.  The error is DataSource.Error: The table has no visible columns and cannot be queried.

(The tables can be accessed via SDK)

Any help would be appreciate.

Thanks.

[v-zhangti]

Hi, @Lluvia 

Please refer to the following links in the hopes of helping you.
Amazon Redshift DataSource.Error: The table has no... - Microsoft Fabric Community

Solved: Local data storage using ODBC with AWS Athena - Microsoft Fabric Community

Solved: Connecting AWS Athena to PowerBI - Preview is eval... - Microsoft Fabric Community

Power Query Amazon Athena connector - Power Query | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.