Power BI with Greenplum

[dengyue]

Hi experts, Our organization decided to use Greenplum as analysis database, but I can't find a connection for Greenplum. Does anyone has such experience or best practice to use Power BI with Greenplum? Thanks in advance. Regards, Yue

[Anonymous · Accepted solution]

Hi @dengyue ,

After I check the document of greenplum datasource, I found it is postgresql based on datasource. You can try to use postgresql connector to get data.

About the Greenplum Architecture

Greenplum Database is based on PostgreSQL open-source technology. It is essentially several PostgreSQL disk-oriented database instances acting together as one cohesive database management system (DBMS). It is based on PostgreSQL 8.3.23, and in most cases is very similar to PostgreSQL with regard to SQL support, features, configuration options, and end-user functionality. Database users interact with Greenplum Database as they would with a regular PostgreSQL DBMS.

Connecting Power BI To PostgreSQL

Regards,

Xiaoxin Sheng