Postgresql odbc driver4/6/2023 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. 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 configured so that it can't be directly accessed from the internet (recommended for security), you'll need to use an on-premise data gateway for refreshes. For other hosting environments, consult your hosting provider about configuring your PostgreSQL for direct access from the internet. This is natively supported for PostgreSQL hosted in Microsoft Azure. To refresh data from the Power BI service without an on-premise data gateway, PostgreSQL must be hosted in a manner that allows direct connection from the Power BI services on Azure. Refreshing is supported both through the cloud in the Power BI service and also on premise through the on-premise data 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 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |