Support for newer NpgSQL (PostgreSQL) version

Anonymous — Mon, 17 May 2021 15:10:34 GMT

Hello,

The follow problem was encountered: When you have `FOREIGN TABLE`s in the database, they are not shown in the the table/schema selector within Power BI.

After some investigation I noticed this ahs been fixed in a new NpgSQL version (4.1.4), whereas the Power BI application is shipped with an older 4.0.10. I assume this is because the newer NpgSQL versions are using an incompatible (?) .NET setup for Power BI. The following is needed: https://github.com/npgsql/npgsql/pull/2525

In order for me to debug this some more, I would like to get some insight on the following points:

- How can I see which NpgSQL version Power BI is using? As the documentation says the following "while on-premise refresh will use the local installation of NpgSQL, if available, and otherwise use NpgSQL 4.0.10".

- Did anyone successfully used a newer NpgSQL connector?

- This functionality can be easily backported to 4.0.11. Would it be possible to use a different version in the Power BI environment?

If the route of backporting is taken, it might also be an idea to ship this standard in the new Power BI versions.

Update: A backport has been deployed to the supported branch of NpgSQL 4.0.x: https://github.com/npgsql/npgsql/releases/tag/v4.0.12. This, however, still does not show the FWD tables in Power BI.

Ref: Postgres, NpgSQL, Foreign table

Re: Support for newer NpgSQL (PostgreSQL) version

v-lionel-msft — Thu, 13 May 2021 05:59:46 GMT

Hi @Anonymous ,

Please refer to the link.

PostgreSQL

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Support for newer NpgSQL (PostgreSQL) version

Anonymous — Thu, 13 May 2021 07:37:37 GMT

This is exactly what I tried. My questions still stand.

I created a hotfix to 4.0.x (https://github.com/npgsql/npgsql/pull/3722) and can check if that works once it is released.

But I still would like to see if PowerBI is connected with my CAG installation.

topic Re: Support for newer NpgSQL (PostgreSQL) version in Developer

Support for newer NpgSQL (PostgreSQL) version

Re: Support for newer NpgSQL (PostgreSQL) version

Re: Support for newer NpgSQL (PostgreSQL) version