Forum Discussion
PowerBi to Redshift Authentication
Hi All,
We've managed to resolve this issue without any of your help, here is a video that has a step by step guide on how to set it all up
Hii harrison_greene
Power BI Service does not support user passthrough authentication to Amazon Redshift. In DirectQuery, all queries run using a single dataset credential, so Redshift-native RLS cannot be enforced per end user this is why visuals either break or users see all data. OAuth 2.0 does not change this behavior. Today, the only supported and reliable option is to implement Row-Level Security in Power BI itself (or use pre-filtered Redshift views as a limited workaround).
Are we saying that SSO from PowerBi service to Redshift is not possible as an authentication method?
SSO from Power BI Service to Amazon Redshift is supported only via Microsoft Entra ID (Azure AD) SSO, using the native Amazon Redshift connector + the SSO settings on the gateway/vnet gateway (for DirectQuery).
https://learn.microsoft.com/en-us/power-query/connectors/amazon-redshift
Hi,
The article you linked is very vague, and has no documentation on what provider name should be.
Can you link examples of where this setup has worked, either through community questions or official documentation?
Thank you
