Forum Discussion
Direct Redshift connection with tenant, client and secret params
I am trying to configure a direct connect from Power BI desktop to AWS Redshift, but my connection is not just user and password I need to be able to input the following variables for the connection to be accepted by the Redshift cluster:
client_id=x;
client_secret=x;
idp_tenant=x;
ClusterID=x;
DbGroups=x;
Region=x;
IAMAuth=true
Ususally in a jdbc or odb connection I would be able to input that as part of the url, but I have not been able to find where to input this at the PBI desktop connection dialog
Has anyone been succesful on configuring a connection to Redshift using parameters?
Hi RicardoU
The current Amazon Redshift connector doesn't support adding these variables for connection. As a workaround, you can connect to AWS Redshift with ODBC connection. This is supported in Power BI.
Here are some documentations for your reference:
Using Amazon RedShift with Power BI - Microsoft Community Hub
Power Query ODBC connector - Power Query | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
1 Reply
Hi RicardoU
The current Amazon Redshift connector doesn't support adding these variables for connection. As a workaround, you can connect to AWS Redshift with ODBC connection. This is supported in Power BI.
Here are some documentations for your reference:
Using Amazon RedShift with Power BI - Microsoft Community Hub
Power Query ODBC connector - Power Query | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!