Is there any limitation while using Power BI desktop with Postgress connection?

[Anonymous]

Hi,

I am new to Power Bi.

We are planning to switch from SQL server to Postgress Database in our company. I want to know is there any limitation or Is there anything that I need to take care while connecting Postgress Database to Power BI?

Thanks!

Regards,

Poonam

[v-shex-msft · Accepted solution]

HI @Anonymous,

There is no specific limitation on postgres, it should similar as normal sql connector.(install connection client, input service name and other to connect)

Configuring Power BI Connectivity to PostgreSQL Database

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft,

Thanks for the reply :).

WIll there be any performance issue if we compared Power BI to Postgress connectivity rather than MSSQL?

Regards,

Poonam

[v-shex-msft]

HI @Anonymous,

It is hard to say which one has better performance, maybe you can post to related forum to know more about difference between them.

Regards,

Xiaoxin Sheng