In your Bytespree main dashboard look for your database and head to "Manage Database Settings"
2. Head to the SQL Access tab and click on "Enable SQL Access". PostgreSQL Connection Credentials will be generated for you.
3. Make sure to download the CA Certificate and install it.
4. Add your IP Address in the Admin section of your Team.
Go to Admin --> Server Management --> "Add a new IP Group"
Add your IP address in the new box that was created, give it a name, and click on "Save".
5. Download postgresql ODBC driver https://www.postgresql.org/ftp/odbc/releases/REL-16_00_0005/
Download the .exe file and install it.
6. Open your Microsoft ODBC Data Source Administrator
7. Click on "Add" and choose the PostgreSQL Unicode option
8. Type in your credentials from Bytespree, and click on "Test" to test the connection.
9. Download Power BI. Make sure the bit versions of Power BI and the ODBC Data Source (DSN) driver match (32 or 64 bit). Download the corresponding version of Power BI.
10. Head to Power BI and go to File --> Get Data --> ODBC
11. If successful you should see your database like this:
