Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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!
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!
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |