ODBC Connection with Visio

Hi All, 

I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards. 

In Visio, you have the option to create an organizational chart via a Wizard and "an ODBC-compliant data source". After clicking on our Smartsheets connector, I can select the correct sheet. Yet, visio is unable to "read names from ODBC data source". Can anyone assist? 


ODBC compliant data source.PNG

Smartsheets option.PNG

Select Smartsheet table.PNG

Unable to read names.PNG