Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |