This page will walk you through setting up direct access to your data in Microsoft Power BI, using the built-in connector for Azure Postgresql. (If your data is not hosted on Azure, please refer to Setup: Power BI to use ODBC instead.)

1. Connect to Azure Database for PostgreSQL

Open Power BI, then select Get Data. Search for “postgresql” and choose the Azure Database for PostgreSQL connector.

2. Enter your server & database details

In the new window, enter your server address and database into the corresponding fields.

  Database:     [Your database] Ex: demo.client.reasonautomation.com
  Server:       [Your server] Ex: 9d53a094-4c48-11ee-be56-0242ac120002

3. Enter your credentials

Power BI will ask you to enter your username and password to connect to this database. Your database username and password were emailed to you during account setup. If you have lost your database username or password, and need your credentials reset, please contact us.

⚠️

If you have multiple accounts with Reason Automation, make sure to change the dropdown and apply these settings to the server+database:

4. Congratulations!

You should now have direct access to your Reason-powered Amazon data from within Power BI. Each report is stored as a table in your database, e.g. “inventory_all_listings". Select the table you want and either:

• Click Load to import the entire report into Power BI.
• Click Transform to choose which columns, date ranges, and other views to import.