Connect Redshift to Power BI

With Coupler.io, it’s quite simple to collect and organize your data. It takes a few simple steps to set up the data integration between the data warehouse and the business intelligence tool. Here is what it looks like to connect Redshift to Power BI:

Step 1: Collect data
Start by connecting your Redshift account. Then, configure your data source settings according to your preferences:

• Report type. Table or view is selected by default for easy data retrieval from existing sources. Select custom SQL for precise queries from single or multiple Redshift tables.
• Schema. Specify the schema you want to export.
• Table/view. Enter the name of the specific table or view you wish to load from the database.

Step 2: Organize and transform
Before importing Redshift data to Power BI, preview your data to ensure its accuracy. If necessary, apply data transformations using the following options:

• Edit, Rearrange, Hide, or Add Columns: Customize your dataset structure.
• Apply Filters and Sort Data: Refine your data for better analysis.
• Create New Columns with Custom Formulas: Enhance your dataset with calculated fields.
• Hide and rename Columns: Change column names to make them more descriptive and relevant to your business context. Hide the columns that are of no use to you.
• Blend Data from Multiple Accounts or Apps: Combine data sources for a comprehensive view.

These transformations ensure your dataset is ready for analysis upon import.

Step 3: Load and automate
To finally import data from Redshift to Power BI, follow the in-app instructions to generate the integration URL. Then open the Microsoft Power BI desktop application and click Get data => Web. Insert the copied integration URL and proceed with the data load. Your data from Redshift will first land in the Power Query editor. Here, you can make additional transformations and eventually load the dataset to Power BI. After that, your data is ready for visualization.



Turn on automatic data updates and choose the interval you're comfortable with. Lastly, save and run the importer.

Turn on the automated refresh feature to keep your imported data current. Select the frequency of updates, ranging from monthly to every 30 or 15 minutes. Customize your data refresh by specifying the days of the week, the time slot, and your preferred time zone.

This functionality from Coupler.io ensures that your Power BI reports always reflect the latest data from Redshift