Forum Discussion

pejay's avatar
pejay
Frequent Visitor
8 years ago

PowerBI & Athena ODBC connection problem

Hi everyone,   we try to connect to AWS Athena from PowerBI via their ODBC driver. We encountered a problem with queries that have a with statement, i.e.     with a1 as (      select * from tab...
Need Help
pejay's avatar
pejay
Frequent Visitor
8 years ago

Well, I wanted to know why it doesn't support CTE queries, it seems to be a problem of PowerBI, not Athena ODBC. JFYI: Another workaround is to use Redshift Spectrum.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

pejay,


This is by design, you can submit an idea here.

Regards,
Lydia