Power BI: How to Connect to Athena -- Part 2: Power BI Setup

[@martinamunoz1764]

Thank you Mathew, the video step by step was useful. At the end of the video of the aditional settings, I was not able to do it but for all the video long it was useful and it is working now. Appreciate your knoledge

[@chandankumarv1005]

Thanks Matthew, this was very helpful!!!

[@TheReluctantCoder]

Thank you so much!! It worked!!

[@nickey0207]

Good job Mattrew!

[@indianarasantos2798]

I think the part to connect to the on premises gateway is up to date, do you have any update ?

[@stevanmomcilovic4469]

Hi, is it possible to show same process with AzureAD authentication type? Thanks

[@ram9208]

Hi Thanks for this video. Hoowever, I am not able to configure ODBC online on the gateway. Where do I find this data source settings? I have published my report but am not able to refresh it since I am not able to add athena in gateway. Can you please guide on this?

[@roadtoau]

Hey Matt! Can you explain what the Gateway is?

[@davidwoodley8719]

Hi Matthew, thanks for the very helpful tutorial. Could you explain a little bit more about your gateway please? Do you have it installed on an AWS instance or is this on your local machine? I have managed to connect and retrieve data with Power BI Desktop but have had no luck getting the ODBC connection to work on the machine running our gateway. Thanks in advance!

[@IvanArango-tw8em]

Hi! Did you find a solution? Im having the same issue and I can't solve it

[@mindset.optimism]

Hi, Is there any way we can run custom sql queries on athena using power bill just like Sql Server connector.?

[@S.Ahm_here]

I am unable to fetch from a different data source, it is just showing AwsDataCatalog. is there a workaround?

[@pankajkumar-pe3zd]

can we filter the data before we import into power BI through POWER BI Advance sql query, its not working form me just want to check if i am missing some thing

[@lorenvasquez17]

Hi, Matthew, I wanted to ask about the security of the database. Is it so unsecure to connect with the secret key? Will the database be public?

[@bottonline4544]

Hola Mattew , buen trabajo . no logro hacer la Conexion . me da este error : [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 14, Error Message: Invalid DNS Label found in URI host [Execution ID: ] Saludos

[@brunalopes6250]

Hi Matthew. Where did you got the Secret Key and the Access Key? I'm trying to find these and this is the only thing that I need. BTW you did a great job with the videos!!

[@fishleaf]

Thanks! You can ask your AWS Admin to get the keys. If you are the AWS Admin, you can check Part 1 of the video to see how to create the key!

[@brunalopes6250]

@@fishleaf I got it. I went to the IAM credentials, thank you!

[@viniciusfigueiredo6740]

I get the error: Failed to save modifications to the server. Error returned: 'The following system error occurred: '.... Whats this?

[@snaphooks]

Thanks Matthew. Is it possible to filter the 'databases' from athena using the odbc connection properties, rather than look at all databases using "default"? It would help the user limit the number of tables and views to look through...

[@fishleaf]

Yes. For that you will need to contact your AWS IAM team to modify. As long as they changed the security policies, the key users will only see the tables and databases you want them to see. Please check Part 1 of the video to learn more about the security setup!

[@zedizdead]

Btw tou can use a custom sql statement if you click on the advanced settings on the odbc connection screen. Do you know how refresh and schedule an autoo refresh for a dataset create from Athena datasource? When I go to my dataset settings, refresh scheduling is disabled.

[@fishleaf]

Yes, Athena Connect is an ODBC Connection, and thus Microsoft by design requires you to have a Power BI Gateway set up! You can check out this video for a Power BI Gateway step-by-step set up kzbin.info/www/bejne/f5iceY1oq9N6rs0

[@zedizdead]

@@fishleaf That's what I realised later, even with the data source not being on-premise .. very annoying

[@aswanikarteek]

Followed same steps, It's waiting for DSN to load for ever.

[@jeevanchavan143]

same here , how you resolved it?

[@kiariesamuel2691]

How do I connect to AWS Athena with odbc? any video or documentation

[@indianarasantos2798]

Hey, did you find something ?

[@kiariesamuel2691]

Yes I did Thanks