Message-ID: <gh-postgresql-interfaces-psqlodbc-133@github.com>
From: "spmcn (@spmcn)" <noreply+spmcn@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Wed, 13 Aug 2025 12:56:33 +0000
Subject: [postgresql-interfaces/psqlodbc] issue #133: Syntax error importing tables through Power Pivot in Excel
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 25233969
X-GitHub-Author-Login: spmcn
X-GitHub-Issue: 133
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/133
Content-Type: text/plain; charset=utf-8

I'm getting the following error when trying to import tables using Data Model (aka Power Pivot). This only occurs when trying to import through this Table Import wizard. 

<img width="528" height="568" alt="Image" src="https://github.com/user-attachments/assets/53c0cb8e-b3e3-47fb-947b-e11e6f2a3076" />

it's not unique to just that table, it happens with all my tables:

<img width="860" height="420" alt="Image" src="https://github.com/user-attachments/assets/4104320c-548b-4585-a6f8-7df44293135b" />

I can import okay through Power Query, so I know I'm connected to my database correctly. This only occurs through Power Pivot and Data Model.

I'm using:

- psqlodbc Release 17.00.0004 (32-bit)
- Microsoft® Excel® for Microsoft 365 MSO (Version 2505 Build 16.0.18827.20102) 32-bit