Forum Discussion
External Client connecting to Internal Redshift Serverless Data Share with PowerBI
Good day,
We are trying to implement data share moving from API OAuth2 to Redshift Serverless Data Sharing
1. Is this possible for a external user/client to access aws redshift serverless from powerbi?
2. Would the external client require a gateway?
3. Would the external + internal client require an ODBC installation to connect to Redshift Serverless?
Please help, any thoughts/links/examples on how to achieve data sharing via Redshift Serverless with PowerBI
Regards
Hi icassiem ,
I guess you are looking for redshift conectivity in Power BI.
Any user with appropriate database credentials can connect to redshift database.
If the database is protected with firewall then On premises data gateway connection is required for Power BI service and appropriate VPN configuration is required to connect from Power BI desktop.
Power BI desktop and service natively support redshift database. However you can use ODBC connection as well.
(Microsoft recommends native connector over ODBC).Please refer to this page for more information: https://learn.microsoft.com/en-us/power-query/connectors/amazon-redshift
I hope I answered your question.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
14 Replies
Hi icassiem ,
I guess you are looking for redshift conectivity in Power BI.
Any user with appropriate database credentials can connect to redshift database.
If the database is protected with firewall then On premises data gateway connection is required for Power BI service and appropriate VPN configuration is required to connect from Power BI desktop.
Power BI desktop and service natively support redshift database. However you can use ODBC connection as well.
(Microsoft recommends native connector over ODBC).Please refer to this page for more information: https://learn.microsoft.com/en-us/power-query/connectors/amazon-redshift
I hope I answered your question.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank You very much tharunkumarRTK
this what i was looking for, please clarify below:
1. Power BI desktop and service natively connectivity, i am not sure it's possible for Redshift Serverless?
2. The firewall, would this be internally set on Redshift Serverless DB or clients firewall, if internal can it be dropped or configured how?
1. Power BI desktop and service natively connectivity, i am not sure it's possible for Redshift Serverless?
I believe redshift native connector in power bi does support serverless db as well. However if you want to connect with your redshift profile then it is not possible with native connector..
https://medium.com/@dtyshecky/powerbi-connectivity-with-redshift-serverless-using-odbc-90f2e93e69a32. The firewall, would that be internally set on Redshift Serverless or clients firewall?
internall set from the AWS end.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Hi, @tharunkumarRTK
Apologies, Please Help
The Basic Auth has been rebuffed.
I want to use Native, how do i use DB Credentials with Service SSO?
Would this also be Basic or ?
Power Query Amazon Redshift connector - Power Query | Microsoft Learn
Microsoft Entra ID Single Sign-On (SSO) through Power BI service
Im trying to use Native Connector to Redshift, but we cant expect clients to have a server/ec2 for an on-prem gateway
icassiem
If you want to configure SSO then there are few limitations that you should note1. it only works with direct query data model
2. I guess SSO works with Microsoft AAD (Entra) based authentication only but not with basic auth.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
