title: Connect to a Postgresql database using power query in Excel
body: <p>I am struggling with the above - I've installed PowerQuery (64 bit Excel 2013 setup) and under the database connection options, despite following the instructions here to download the Ngpsql data provider for PostgreSQL:</p>
  
  <p><a href="https://support.office.com/en-ie/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4?ui=en-US&amp;rs=en-IE&amp;ad=IE" rel="nofollow noreferrer">https://support.office.com/en-ie/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4?ui=en-US&amp;rs=en-IE&amp;ad=IE</a></p>
  
  <p>I can still only see a limited set of options under under the database list, which do not include a PostgreSQL database. Now having hunted around on the web I found this thread:</p>
  
  <p><a href="https://superuser.com/questions/950100/connect-to-postgresql-database-from-excel-2013-power-query-with-npgsql">https://superuser.com/questions/950100/connect-to-postgresql-database-from-excel-2013-power-query-with-npgsql</a></p>
  
  <p>Which seems to suggest that the reason I cannot see the Postgresql option is that I am not using an OfficePro installation (think it was home edition).</p>
  
  <p>Does anyone have any pointers - any workaround for this? Or do I really have to get a different version of office to get data from a Postgresql db, short of converting the database into Access or something? Thanks</p>