Connecting Redshift Spectrum to PowerBI

Hi MarcSitges 

I connect using the ODBC connector. You will need to configure the ODBC connection.

You probably have already, but download and install the ODBC driver for Athena

https://downloads.athena.us-east-1.amazonaws.com/drivers/ODBC/v2.0.1.1/Windows/AmazonAthenaODBC-2.0.1.1.msi 

There are some configuration articles here https://docs.aws.amazon.com/athena/latest/ug/odbc-v2-driver-getting-started.html 

Here is how I setup everything

• Install the driver
• Open ODBC data Sources in Administration mode
• Click on Add 
• Find the Athena Driver and click on Finish
• You will me by a pop up
• Give The connection a name
• Enter the AWS Region
• The rest you fill out like in the screenshot that suits your comnpany's connection configuration 

   

• Click on test to see if it works
• if it does go to Power BI
• Open the ODBC connector
• Choose from the DSN dropdown, the connection you just created
• You can also do an SQL query if needed.
• You will be then promted to add the credentials

If you want to refresh the source automatically, you will need a Power BI Gateway

Setting up the credential part of the gateway should look like this 

Hope this helps

Thanks

Joe

If this post helps, then please Accept it as the solution