topic Using URI to connect to datasource in Power Query

Using URI to connect to datasource

Anonymous — Thu, 19 Aug 2021 14:57:53 GMT

Is there any way to connect to a data source via URI?
For example to Postgres with a URI like:

postgres://user:password@host:5432/database

Re: Using URI to connect to datasource

lbendlin — Fri, 20 Aug 2021 18:58:44 GMT

Only for a limited set of data sources that are accessible via Web.Contents() or ODATA . All databases require their own driver, native or ODBC based.

Re: Using URI to connect to datasource

Anonymous — Wed, 25 Aug 2021 06:47:59 GMT

Hi Anonymous ,

You can try to connect PostgreSQL as follows using Server name and Database name.

For more details, please kindly refer to this document.

Best Regards,

Stephen Tao

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