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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @SasidharChalla ,
Glad the problem was solved, it's my pleasure!😊
Best regards,
Community Support Team_yanjiang