Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
2 years ago
Solved

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 p...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    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

     

     

     

tharunkumarRTK's avatar
tharunkumarRTK
Super User
2 years ago

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

 

 

 

icassiem's avatar
icassiem
Post Prodigy
2 years ago

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

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    icassiem 

    If you want to configure SSO then there are few limitations that you should note

    1. 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

     

    • icassiem's avatar
      icassiem
      Post Prodigy
      2 years ago

      tharunkumarRTK 

      I dont know what to do 😞 

      i cant use Basic but SSO and need to use Native to Serverless as clients dont have server/ec2 for onprem-gateway

      Please what's my best options, what would you do?