Syntax error importing tables through Power Pivot in Excel

[spmcn]

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.

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

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

[spmcn]

I noticed that this only happens when I select "Add this data to the Data Model." So I can import one table at a time, but selecting multiple tables forces me to checkmark "Add this data to the Data Model" and that's when I get the error.

[davecramer]

Sorry for the late reply. I don't really know how to help you here. What version of ODBC are you using?