I have installed Power BI Desktop and connected it to PostgreSQL database server. My understanding is this works because Power BI Desktop ships with npgsql, which is required for this connections to work properly. However if I try to create the same connection within Excel (Data > Get Data > From Database > From PostgreSQL Database) I get the error as shown below. Both Excel and Power BI are 64-bit versions.
Since this is a company machine it can be difficult to get approval for additional installation of Npgsql. I am hoping there is a way to point Excel's connectors to the version being used by Power BI. But let me know if a separate install should be required to connect Excel to PostgreSQL.
