I want connect to Postgres ODBC data source with direct query enabled. So I took this sample project, https://github.com/Microsoft/DataConnectors/tree/master/samples/ODBC/SqlODBC, point Config_Driver...
Even i am running into the same problem.
I have tried using Table.Distinct to remove duplicate type name, but still getting the same problem.
xsgao_pbi can you please share how you got it working?