Forum Discussion
Local data storage using ODBC with AWS Athena
HiAnonymous,
Athena also has 30.000 rows limit .
The CData Amazon Athena Connector contains an embedded SQL Engine that pushes supported SQL operations to the data source and processes unsupported operations client-side (Query Folding).
Please check if the following is useful ：https://www.cdata.com/drivers/athena/powerbi/?gclid=EAIaIQobChMIsN7R_vCx7wIVQteWCh3GGQv-EAMYASAAEgI3TfD_BwE
https://blog.openbridge.com/how-to-connect-microsoft-power-bi-to-amazon-athena-c2cc4f295ac4
Hope it helps.
Best Regards,
Caitlyn YanIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous , In case the connection is direct query, Power query the database. In case of import mode it stores the data
refer these to understand those
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Not quite what I was saying. I still want to import some parts of my table locally. I was just wondering if the Athena has 30.000 rows and I use ODBC to run a query that filters by Date and only returns 2.000 rows, will only the 2.000 rows be stored in the report, or will ODBC import the whole database to run that query locally.
It's a performance issue kinda
Thank you!!