In Power BI Desktop, you can connect to an Amazon Redshift database and use the underlying data just like any other data source in Power BI Desktop. This release of the Amazon Redshift connector is in preview, and is subject to change.
To get access to the Amazon Redshift connector, you first need to enable this preview feature. In Power BI Desktop, select File > Options and settings > Option then in the Options window, select the Preview Features section and enable Amazon Redshift, as shown below.
When you check that box, you turn on the Amazon Redshift preview feature. You'll need to restart Power BI Desktop for the change to take effect - that's the case whenever you enable or disable a preview feature.
Once you restart, the preview features is available.
Once you've enabled to preview feature, to connect to an Amazon Redshift database select Get Data from the Home ribbon in Power BI Desktop. Select Database from the categories on the left, and you see Amazon Redshift (Beta).
In the Amazon Redshift window that appears, type or paste the name of your Amazon Redshift server and database into the box. As part of the Server field, users can specify a ort in the following format: ServerURL:Port
When prompted, put in your username and password.
Once you successfully connect, a Navigator window appears and displays the data available on the server, from which you can select one or multiple elements to import and use in Power BI Desktop.
Once you make selections from the Navigator window, you can either Load or Edit the data.
There are all sorts of data you can connect to using Power BI Desktop. For more information on data sources, check out the following resources: