Forum Discussion
i want get the data from the database
yunyun You have two choices. Install an https://www.bing.com/ck/a?!&&p=dbd9a24b81221bf9be172f01e17e2573b0888f3d618fdc5d525e9e2e64621936JmltdHM9MTY1NDE3MTYyNSZpZ3VpZD1mN2VhNWIzMy1kNWJmLTRmMjAtODVjYy1kMzdjOGVkZDg2YmUmaW5zaWQ9NTE3Mw&ptn=3&fclid=84d8c959-e26c-11ec-ade7-3ddf2f9d0b1f&u=a1aHR0cHM6Ly9vZGJjLnBvc3RncmVzcWwub3JnLw&ntb=1 for PostgreSQL and then follow the https://www.bing.com/ck/a?!&&p=7a0bb69c3f5811109f90f4180fbc1e29d6db4c12371f9069ef39406d9a10aa36JmltdHM9MTY1NDE3MTY1MyZpZ3VpZD0yZmVmZDFjYS1kNjQ2LTQzOTktYWZhMC0xNzhjYjJiZjVkODMmaW5zaWQ9NTI0NA&ptn=3&fclid=955e7428-e26c-11ec-ab79-c93e22a6d4f3&u=a1aHR0cHM6Ly9kb2NzLm1pY3Jvc29mdC5jb20vZW4tdXMvc3FsL2ludGVncmF0aW9uLXNlcnZpY2VzL2ltcG9ydC1leHBvcnQtZGF0YS9jb25uZWN0LXRvLWFuLW9kYmMtZGF0YS1zb3VyY2Utc3FsLXNlcnZlci1pbXBvcnQtYW5kLWV4cG9ydC13aXphcmQ&ntb=1. Install a PostgreSQL driver and follow the https://support.microsoft.com/en-us/office/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a?redirectsourcepath=%252farticle%252fbf941e52-066f-4911-a41f-2493c39e69e4 path. Only real trick is ensuring that your firewall allows the IP address where Excel is attempting to connect from. That's it. Connection string is just off your URL, available from the console. Login and password are whatever you define.