PowerBI service to Redshift Connection

[SasidharChalla]

As per Integrate Power BI with Amazon Redshift for insights and analytics | AWS Big Data Blog

I could able to setup PowerBI gateway , But i'm suprised to see that app.powerbi.com(Not PowerBI desktop) didn't list Redshift as one of its DataSource Types(Alpahbetically sorted in the below image)

So I had to try ODBC connection and setup ODBC string as 
"Driver={Amazon Redshift (x64)}; Server=<<server-endpoint>>.redshift-serverless.amazonaws.com; Database=<<Database-name>>"

But I couldn't setup the connection as I got this error in the end. Looks like the driver isn't recognizable. FYI I installed Redshift driver on Gateway instance too

Attahced is the image in gateway instance where redshift driver is installed.

Is there any documented procedure that setups connection between PowerBI.com and redshift cluster(through on-prem Data gateway). Thanks.

[v-yanjiang-msft]

Hi @SasidharChalla ,

This is a quite detailed reference about connecting Amazon RedShift with Power BI:

Using Amazon RedShift with Power BI - Microsoft Community Hub

I suggest you connect with ODBC connector in Desktop also, please try again by the blog.

Best regards,

Community Support Team_kalyj

[SasidharChalla]

Awesome, That worked like a charm!!!

I was inputting ODBC connection string in wrong format
i.e, "Driver={Amazon Redshift (x64)}; Server=<<server-endpoint>>; Database=dev"

Which is throwing an error.

Instead it should be in format "dsn=<<Name of the datasource configured inside the gateway>>"

Thanks again @v-yanjiang-msft  for helping out 🙂

[v-yanjiang-msft]

Hi @SasidharChalla ,

Glad the problem was solved, it's my pleasure!😊

Best regards,

Community Support Team_yanjiang