Discovered this useful set of advanced options for Power Query to access SQL server.
http://cwebbbi.wordpress.com/2014/09/29/advanced-options-for-loading-data-from-sql-server-with-power-query/
--Tom