Skip to main content

Integration

Maintained by AEC Integrations

How Amazon Redshift and Power BI exchange data

Amazon Redshift Amazon Web Services Power BI Microsoft

Data flows aren’t documented yet

We’re cataloguing what each integration syncs.

Native

Power BI → Amazon Redshift

Built by Microsoft

←Receives from Power BI

Microsoft ships a first-party Power Query connector for Amazon Redshift, at General Availability, supported in Power BI semantic models and dataflows, Fabric Dataflow Gen2, Power Apps dataflows and Dynamics 365 Customer Insights. It supports both Import and DirectQuery, authenticates with an Amazon Redshift Basic account, a Microsoft account or an organizational account, and exposes Redshift tables, views, external tables, external views and system tables through the Navigator. Power BI reads from the warehouse; nothing is written back.

Directory updates

Know when new tools and reviews land

AEC Integrations is live and still growing. Add your email for occasional updates as we expand the directory with new tools, integrations, and reviews.