This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
| Item | Description |
|---|---|
| Release State | General Availability |
| Products | Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) Power Apps (Dataflows) Dynamics 365 Customer Insights |
| Authentication Types Supported | Amazon Redshift Basic Microsoft account Organizational account |
Note
Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
To connect to Amazon Redshift data:
Select the Amazon Redshift option in the Get Data selection.
In Server, enter the server name where your data is located. As part of the Server field, you can also specify a port in the following format: ServerURL:Port. In Database, enter the name of the Amazon Redshift database you want to access. In this example, contoso.redshift.amazonaws.com:5439 is the server name and port number, dev is the database name, and Data Connectivity mode is set to Import.
You can also choose some optional advanced options for your connection. More information: Connect using advanced options
After you have finished filling in and selecting all the options you need, select OK.
If this is the first time you're connecting to this database, enter your credentials in the User name and Password boxes of the Amazon Redshift authentication type. Then select Connect.
More information: Authentication with a data source
Once you successfully connect, a Navigator window appears and displays the data available on the server. Choose one or more of the elements you want to import.
Once you've selected the elements you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor.
Select either the Import or DirectQuery data connectivity mode, and then select OK.
To connect to Amazon Redshift data:
Select the Amazon Redshift option in the Power Query - Choose data source page.
In Server, enter the server name where your data is located. As part of the Server field, you can also specify a port in the following format: ServerURL:Port. In Database, enter the name of the Amazon Redshift database you want to access. In this example, contoso.redshift.amazonaws.com:5439 is the server name and port number, and dev is the database name.
You can also choose some optional advanced options for your connection. More information: Connect using advanced options
If needed, select the on-premises data gateway in Data gateway.
Select the type of authentication you want to use in Authentication kind, and then enter your credentials.
Select or clear Use Encrypted Connection depending on whether you want to use an encrypted connection or not.
Select Next to continue.
In Navigator, select the data you require, and then select Transform data. This selection opens the Power Query Editor so that you can filter and refine the set of data you want to use.
Power Query provides a set of advanced options that you can add to your query if needed.
The following table describes all of the advanced options you can set in Power Query.
| Advanced option | Description |
|---|---|
| Provider Name | Provides an Amazon Resource Name (ARN), which uniquely identifies AWS resources. |
| Batch size | Specifies the maximum number of rows to retrieve at a time from the server when fetching data. A small number translates into more calls to the server when retrieving a large data set. A large number of rows may improve performance, but could cause high memory usage. The default is single row fetch. |
| SQL Statement | For information, go to Import data from a database using native database query. This option is only available in Power BI Desktop. |
We support Microsoft Entra ID SSO through both Power BI Service (cloud) and also through the on-premises data gateway. For more information about enabling Microsoft Entra ID SSO for all connectors, go to Overview of single sign-on (SSO) for on-premises data gateways in Power BI.
To configure a new connection in Power BI service:
In Power BI service, select Admin portal from the settings list.
Enable the Redshift SSO option.
Before you can enable Microsoft Entra ID SSO for Amazon Redshift, you must first enable Microsoft Entra ID SSO for all data sources that support Microsoft Entra ID SSO with an on-premises data gateway:
In Power BI service, select Admin portal from the settings list.
Under Tenant settings, enable Azure AD Single-Sign On (SSO) for Gateway.
Once you've enabled Microsoft Entra ID SSO for all data sources, then enable Microsoft Entra ID SSO for Amazon Redshift:
Enable the Redshift SSO option.
Select Manage gateways from the settings list.
Select a gateway, and then select Choose Data Source.
Under the Data Source Settings tab, enter a value in Provider Name. The Provider Name parameter is required when using Microsoft Entra ID and needs to be specified in Advanced settings.
Also select Use SSO via Azure AD for DirectQuery queries.
Training
Module
Get data in Power BI - Training
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.