Direct Redshift connection with tenant, client and secret params

[RicardoU]

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;

plugin_name=AzureAD

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?

[Anonymous · Accepted solution]

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!