Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Service Security When Using Direct Query

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

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.