Then, use PostgreSQL.Database(server as text, optional options as nullable record) as table There you will set up connection to the DB. To properly connect to your database you should (in Excel) go to Data/New Query/From Database/From PostgreSQL Database. It is another connector - it connects your table to PowerQuery.Īlso you're trying to use MS SQL Server connection string to connect to PostgreSQL. As Carl says, do not touch anything like provider=.1. I tried to use connection string from old file and enter this: provider=.1 ĭata source=$EmbeddedMashup(10245e6d-0d7e-4d2c-a98e-ec01c3a30e6c)$ location=monthly_stats Įxtended properties="UEsDBBQAAgAIAJpYcEnkIV3hrAAAPssAAAASABwAQ2Ĭould you please provide me a working example of connection string to read data from ODBC data source in Excel 2016 Get&Transform?įirst, you should not edit a connection string that appears in the properties of a datasources (or can be found in Data/Connections).
is not allowed, and Excel suggests to use SqlCapabilities, and after they also fail, it asks for a connection string. Source = Odbc.DataSource("dsn=PostgreSQ元2", ), A connection string I previously successfully used in Excel 2013 documents fails. Trying to connect ODBC data source and it asks for a connection string. I'm using Excel 2016's Get & Transform to connect to a Postgres DB.
0 kommentar(er)
