Forum Discussion
We couldn't fold the expression to the data source. PostgreSQL DirectQuery
I'm experiencing the same issue with AWS RDS hosted PostgreSQL. Some tables work fine and some complicated measures do go through quite easily, but on some tables or views there seem to be a problem. Some basic queries like querying the store names from a table with 17k records cause an error. That shouldn't be an issue. When I run a similar query in the db theres no errors. Theres only 4 distinct values in that column and if I do a count or distinct count of those values then it works. All the summarizable fields in the that table work fine but text columns don't. On a different table some of the text columns work and some don't.
I actually continued the tests and one weird thing came up. One of the connected tables that I have the problem with is a view in the database. There's a store name and product name fields in the view that aren't working and giving me the aformentioned error message. I took the ddl from that view and created a new query to the database with that views exact SQL statement and surprise surprise those two fields don't give any errors.
What on earth is going on?