Amazon Redshift is a supported connector within Power Query and supports Microsoft Entra ID (Azure AD) Single Sign-On (SSO) scenarios through Power BI Service and Power BI semantic models. Documentation for the Amazon Redshift connector explicitly references support for Microsoft Entra ID SSO in the Power BI ecosystem.
However, Amazon Redshift is not currently listed as a supported native connector in Excel Power Query. The current Excel Power Query connector matrix includes many database connectors but does not include Amazon Redshift.
This creates a capability gap between Power Query experiences across Microsoft products. Customers that use Amazon Redshift and Microsoft Entra ID authentication can leverage modern authentication and SSO in Power BI, but must adopt alternative architectures or workarounds when Excel is their primary data consumption tool
Requested enhancement: Add native Amazon Redshift connector support to Excel Power Query, including support for Microsoft Entra ID/OAuth authentication methods and SSO capabilities where available.
Current Workarounds:
Power BI semantic models
Dataflow Gen1/Gen2
Generic ODBC connectivity
