PowerBI 连接PGSQL 可使用NPGSQL (选择postgresql),或者ODBC
ODBC 连接PGSQL:
- 下载Pgsql Driver: PostgreSQL: File Browser
- PBI 连接:
powerquery advanced editor:
let
_Query = "select * from table_a",
_Conn_Info = "Driver={PostgreSQL Unicode(x64)};" & "Server=" & server_odbc & ";Port=80;Database=" & database,
_Source = Odbc.Query(_Conn_Info, _Query)
in
_Source
PGSQL 连接时,可能Boolean列传入非TRUE/FALSE, 而变成0/1 (NPGSQL 还是TRUE/FALSE),
可以设置参数BoolsAsChar=0:
let
_Query = "select * from table_a",
_Conn_Info = "Driver={PostgreSQL Unicode(x64)};" & "Server=" & server_odbc & ";Port=80;Database=" & database & ";BoolsAsChar=0",
_Source = Odbc.Query(_Conn_Info, _Query)
in
_Source
(Boolean columns are returned as strings · Issue #302 · r-dbi/odbc · GitHub)
其他可能设置的参数,可参考官网:
How to specify as a connection option (postgresql.org)
官网其他ODBC常见问题解答: