Connect Power BI to the Data Warehouse

This article provides instructions for connecting Microsoft's Power BI with your organization's data warehouse on a Windows 10 machine.

Prerequisites

Before following the steps below, ensure you have:

  • Purchased and activated the data warehouse feature.
  • Reviewed the Important Notes section of BI Connectivity via the Data Warehouse article.
  • A Core user account with admin privileges enabled for the organization you wish to connect to Power BI.
  • Contacted Resolver Support to obtain the Amazon certificate required to complete the steps in section 2 below.

1. Import the Certificate

To import the Amazon certificate:

  1. If you haven't already done so, contact Resolver Support to obtain the required Amazon certificate.
  2. Enter mmc in the Windows search box, then click Open to open the Microsoft Management Console.
     Microsoft Management Console in the search results.
  3. Click File > Add/Remove Snap-in...
    The Add/Remove Snap-in... option from the File menu.
  4. Select Certificates from the Available snap-ins pane on the left, then click Add to move it to the Selected snap-ins pane on the right.
    The Add or Remove Snap-ins window.
  5. Click OK to close the window to return to the console.
  6. Expand Certificates - Current User in the pane to the right.
  7. Right-click Trusted Root Certification Authorities, then select All Tasks > Import to open the Certificate Import Wizard window.The Import option in the console.
  8. From the second screen of the installer, click Browse.
    The Certificate Import wizard.
  9. Navigate to the saved location of the Amazon certificate, then click Open.
    Selecting the certificate file after clicking Browse.
    If you can't see the certificate file after clicking Browseselect All Files (*.*) from the dropdown menu at the bottom-right of the window.
  10. Complete the steps in the wizard, then close the console. It's not necessary to click Save when prompted.

2. Connect the Warehouse with Power BI

To establish a connection between the data warehouse and Power BI:

  1. Open Power BI.
  2. Click theGet Data icon.
    The Get Data icon in Power BI
  3. Select PostgreSQL database in the pane to the right, then click Connect.The Get Data window in Power BI.
  4. Follow the instructions in the BI Connectivity via the Data Warehouse article to access the data warehouse details from your Core user account page.
    The Data Warehouse settings accessible from your Core admin user page.
  5. Paste the Domain URL from your Core user page in the Server field.
  6. Paste the Database Name from your Core user page in the Database field.
    The Server and Database fields in Power BI.
  7. Click OK.
  8. Paste the username and password from your Core user page in the User name and Password fields. 
    The User name and Password fields in Power BI.
  9. Click Connect to complete the process.