The purpose of this document is to provide step by step instructions on connecting your Power BI workbook to your datasets in Redshift.
Accessing Your Workbook
Once you have the workbook and download it, launch Power BI and open the workbook by clicking “Open Recent Files” and navigating to where you saved the file on your desktop.
Once you open your workbook, we want to make sure you’re working in the latest version of Power BI (this should be the current month’s version, such as February 2020 or you can view here). To do this, go to File → Help → About.
If you do not have the latest version, you can download it here.
Swapping Data Sources in Template
Once you have launched your workbook and made sure you’re in the latest version of Power BI, you will need to swap out the demo dataset for your own dataset.
- Navigate to the Home ribbon and click either “Edit Queries” (if you’re on the older version) or “Transform Data” (if you’re on the newest version). This will open the Power Query Editor.
- All tables in the data model will be displayed under “Queries” on the left.
- Selecting a query will populate the “Applied Steps” pane on the right with all steps that have been made in the creation of the query. Click the gear next to “Source”.
- This will open a new window where a new server and database connection can be established. You’ll enter the following information that was provided by Alight:
- Server: “HOST:PORT”
- Note that a colon and the port number will need to be appended to the end of the server URL/host name.
- Database: “Client_Name”
- “Data Connectivity mode” should be set to “Import”.
- Click OK to open the next prompt for credentials.
- Server: “HOST:PORT”
- Enter the user name & password provided by Alight. Once credentials have been entered and the connection has been established, click on the gear next to “Navigation” in the Applied Steps list.
- From here, you will see the tables & views that currently live in ChannelMix. Open the ChannelMix client folder and navigate to the dataset (view) that should be flowing into this dashboard (you can find this in the dashboard documentation, ie. v_oneview_media_and_conversion). After selecting the dataset, clicking “OK” will load the data and apply the remainder of the steps outlined in the Applied Steps pane.
- Complete steps 4 and 5 for every query with the warning symbol.
- All tables in the “data_tables” folder
- Once finished, click “Close & Apply” in the Home ribbon of the Power Query Editor. This will apply all changes, load your dataset into the dashboard and close the Power Query Editor.
The dashboard is now powered by your data!