Forum Discussion
Unable to filter rows with Athena ODBC data source
I would try a work around by filtering the data at the source (get data screen). so when you connect to PBI, under advanced options connect by using "SQL statement" - enter a query with where Clause filtering by event_ID 303.
Hi Anonymous & Abdelh One question....how could you scheduled the updates via the On-prem data gateway using AWS Athena (from app.powerbi.com)
Im trying to do the same...but the connection string to properly work should be something like:
Driver=Simba Athena ODBC Driver;AwsRegion=us-east-2;S3OutputLocation=s3://bucket_name-xx;AuthenticationType=IAM Credentials
But seems that the connection string required is taken directly from the Simba ODBC driver...so it's something like: dsn=Sample Simba Athena ODBC DSN
So at the end of the day it doest work...because it needs the full conexion string but the report its uploaded with the "short one" not the "full one". And also the conextion string on app.powerbi.com it's not editable
Thanks
How are you trying to add this connection to the gateway? I configured mine after uploading the report that contained it, that is, went into the configurations of the datasource and added it to the gateway when prompted.
For the life of me, I can't understand why we still need a gateway for two cloud services to talk to each other, that drives me crazy!