Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Publishing a report with Amazon Athena connection

Hello all!  I connected to Athena on Desktop using the Athena Connector, although that still did require me to install and set up ODBC (Simba Athena). I published the report to Service, when I try...
Need Help
  • ibarrau's avatar
    ibarrau
    3 years ago

    Sure. Amazon Athena is just a bridge to the source like Amazon S3 (data lake). The data is hosted at the AWS cloud. In order to work with PowerBi you need a driver and a gateway. If you install that in a local VM, you are getting data from cloud (aws) to on premise (local vm) and then to cloud again (PowerBi Service). That's a waist of time and processing. In order to keep it always on cloud you can use EC2. EC2 is the name AWS Services has picked for Virtual Machines on AWS Cloud. Installing the gateway there can help keeping the refresh clean and fast.

    I hope that make sense,

Anonymous's avatar
Anonymous
Not applicable
3 years ago

It does make sense, thank you ibarrau! Hopefully our client is already using an EC2, because the report only needs to be refreshed once a month. Sorry to ask so much, but just in case an EC2 would not be viable (I assume the cost of one would be quite high for the utility we'd be getting out of it), is there any other way you would reccomend connecting data on Athena to Power BI service? 

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
3 years ago

Hi. You are welcome. No. That's the best I have found out when I was working on that project. I'm not an AWS expert, so I'm not sure if there is another service like databricks that can read S3 data in order to get it from PowerBI.

Regards