Excel Power Query Can't Access Postgresql Views

Question

I'm setting up Excel Office 365 to access one of our PostgreSQL (9.6) databases via Power Query. Specifically, I'm trying to connect to a View I wrote to return a particular data set.

We're using an ODBC DSN for the connection, using the Postgres Unicode ODBC driver.

I have a weird problem where on my PC this all works fine. But, on a co-workers laptop, it fails. I can connect to a real table on his, but not to a view. The error message is extremely terse. It simply says Error=Table. I'm not sure what that means, except perhaps it's telling me that it can only connect to tables? But if so, why only on that machine?

This is the actual error I get:

DataSource.Error: ODBC: ERROR [HY000] Error while executing the query Details: DataSourceKind=Odbc DataSourcePath=dsn=uranus_emd OdbcErrors=Table

Henry · Accepted Answer · 2020-01-09 11:57:34Z

0

I was able to solve this by installing an actual .NET connector on the PC.

answered Jan 9, 2020 at 11:57

Henry

6203 gold badges9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nick McEwen · Accepted Answer · 2021-01-27 11:15:27Z

0

I also see this problem using VBScript to access a postgres VIEW through an ODBC driver.

I had to work around it by expandingt the details of the query to use only TABLES and effectively recreate the VIEW in SQL

answered Jan 27, 2021 at 11:15

Nick McEwen

1

Comments

Ekkarat Wareesing · Accepted Answer · 2019-12-27 15:15:42Z

-2

Get node.js http://microsoft.com/[email protected]/ import sequence from '@start/plugin-sequence' import find from '@start/plugin-find' import read from '@start/plugin-read' import babel from '@start/plugin-lib-babel' import write from '@start/plugin-write'

const babelConfig = { // … babelrc: false, sourceMap: true, }

export const task = () => sequence( find('src/**/*.js'), read, babel(babelConfig), write('build/') )

edited Dec 27, 2019 at 15:15

answered Aug 9, 2019 at 14:51

Ekkarat Wareesing

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

Excel Power Query Can't Access Postgresql Views

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related