If you can avoid it, don't use column names with spaces. However some tools do this automatically. To make the SQLDataSource work with tables with spaces, use "sql.sqlserver.quoteColumnNames: true" in server.properties, as explained here:
Manage space
Manage content
Integrations