Configure Power BI to Connect to a Virtual PostgreSQL Data Interface

Perform the following steps to configure Power BI to connect to a virtual PostgreSQL data interface:
  1. Open the Power BI Desktop application.
  2. Click
    Get data from other sources
    .
    Power BI Desktop Homepage
    The
    Get Data
     dialog box is displayed.
    Get Data Dialog
  3. In the search box, search for PostgreSQL and select
    PostgreSQL database
    .
  4. Click
    Connect
    .
    Select PostgreSQL database
  5. In the
    PostgreSQL database
     dialog box, provide the following details:
    • Server:
      dm-virtualpostgres.cloud.rockwellautomation.com
       (Production URL).
    • Database: The name of the project in
      FactoryTalk DataMosaix SaaS
      . For example, check-46.
  6. Click
    OK
    .
    PostgreSQL Database Dialog
  7. In the
    PostgreSQL database
     dialog box, provide the following details:
    • Username: Refer to the Client ID generated while registering the application.
    • Password: Refer to the Client Secret generated while registering the application.
  8. Click
    Connect
    .
    PostgreSQL database Dialog
    The
    Navigator
     dialog box displays the list of supported tables.
  9. Select the required table checkboxes and click
    Transform Data
    .
    Navigator Dialog box
    The
    Power Query Editor
     dialog box is displayed.
  10. Under the
    File
     menu, click
    Advanced Editor
    .
    Power Query Editor Dialog
  11. In the
    Advanced Editor
     dialog box, provide the sample query and click
    Done
    .
    Advanced Editor Dialog
    Based on the query, the data will be populated in the
    Excel
     format.
    Final Output
    NOTE:
    For more information on the supported tables and schema, refer to Supported Tables and Schema.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal