Power BI Service Security When Using Direct Query

[Anonymous]

Hello,

I have a question. When we use AWS Redshift as data source as a connection, how can we implement security in PBI service. We want to enable Windows Authentication or SSO for every user when he/she tried to view the report. But when we set up gateway for Redshift we will be giving Service Account/Password, will that not by pass the SSO? I am not worried about RLS here my concern is regarding backend. What are my options in my case? 

Thanks

[v-juanli-msft]

Hi @Anonymous 

You could refer to the offical document:

https://docs.microsoft.com/en-us/power-bi/service-gateway-sso-overview

It said that the on-premises data gateway supports SSO using DirectQuery, which it uses to connect to on-premises data sources.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@v-juanli-msft 

The supported connectors supported now does not include AWS Redshift. Correct me if I am wrong.

We currently support the following data sources:

• SQL Server (Kerberos)
• SAP HANA (Kerberos and SAML)
• SAP BW (Kerberos)
• Teradata (Kerberos)
• Spark (Kerberos)
• Impala (Kerberos)

[v-juanli-msft]

Hi @Anonymous 

You are right.

Best Regards
Maggie