If the connection is not encrypted, you'll be prompted with the following message. Then select Connect.įor more information about using authentication methods, go to Authentication with a data source. Select the level to apply the authentication settings to.
BI TOOLS FOR POSTGRESQL PASSWORD
If this is the first time you're connecting to this database, input your PostgreSQL credentials in the User name and Password boxes of the Database authentication type. Select either the Import or DirectQuery data connectivity mode. In the PostgreSQL database dialog that appears, provide the name of the server and database. Select the PostgreSQL database option in the connector selection. To make the connection, take the following steps:
Once the matching Npgsql provider is installed, you can connect to a PostgreSQL database. NET version incompatibilities.Ĭonnect to a PostgreSQL database from Power Query Desktop When installing, make sure that you select NpgSQL GAC Installation to ensure NpgSQL itself is added to your machine. The provider architecture (32-bit or 64-bit) needs to match the architecture of the product where you intend to use the connector.
BI TOOLS FOR POSTGRESQL INSTALL
To install the NpgSQL provider, go to the releases page and download the relevant release. In the Power BI service, NpgSQL 4.0.10 will be used, while on premise refresh will use the local installation of NpgSQL, if available, and otherwise use NpgSQL 4.0.10.įor Power BI Desktop versions released before December 2019, you must install the NpgSQL provider on your local machine. If PostgreSQL is hosted in a cloud other than Microsoft Azure (such as AWS, GCP, and so on), you must use an on-premises data gateway for the scheduled refresh to work in Power BI service. Refreshing is supported both through the cloud in the Power BI Service and also on premise through the Gateway. GAC Installation overrides the version provided with Power BI Desktop, which will be the default. PrerequisitesĪs of the December 2019 release, NpgSQL 4.0.10 shipped with Power BI Desktop and no additional installation is required. Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
0 kommentar(er)
