Snowflake DirectQuery can not fold query.

I am attempting to connect to our Snowflake db for the first time with Power BI and two simple tables.  One table works fine, I can put dimensions and measures into a graph and it properly aggregates things without complaing.  My other table however I can display single lists of text fine, but as soon as I add a measure it gives the error: "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..".  I've tried reducing the table down to just two columns by removing the others in the interface, but still has the same problem any time I want to aggregate anything.  I am on version 2.83.5894.961 and also updated to the lastest Snowflake ODBC drivers... What am I missing?