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
