title: Connection string ODBC, Excel 2016 Get & Transform
body: <p>I'm using Excel 2016's Get &amp; Transform to connect to a Postgres DB.
  Trying to connect ODBC data source and it asks for a connection string. A connection string I previously successfully used in Excel 2013 documents fails.</p>
  
  <pre><code>let
      Source = Odbc.DataSource("dsn=PostgreSQL32", [HierarchicalNavigation=true]),
      ops_Database = Source{[Name="ops",Kind="Database"]}[Data],
      public_Schema = ops_Database{[Name="public",Kind="Schema"]}[Data],
      monthly_stats_View = public_Schema{[Name="monthly_stats",Kind="View"]}[Data]
  in
      monthly_stats_View
  </code></pre>
  
  <p>[HierarchicalNavigation] is not allowed, and Excel suggests to use SqlCapabilities, and after they also fail, it asks for a connection string.
  I tried to use connection string from old file and enter this:</p>
  
  <pre><code>provider=Microsoft.Mashup.OleDb.1;
  data source=$EmbeddedMashup(10245e6d-0d7e-4d2c-a98e-ec01c3a30e6c)$;location=monthly_stats;
  extended properties="UEsDBBQAAgAIAJpYcEnkIV3hrAAAPssAAAASABwAQ2
  </code></pre>
  
  <p>But it doesn't work.
  I tried a string from here:
  <a href="https://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/" rel="nofollow noreferrer">https://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/</a>
  without luck.</p>
  
  <p>Could you please provide me a working example of connection string to read data from ODBC data source in Excel 2016 Get&amp;Transform?</p>