OLE DB or ODBC error: Specified method is not supported

Hi,

I am having an issue that I'm not too sure how to figure it out.

Context:
I have one model that is imported, the other is using direct query. They are pretty much mechanically exactly the same, however, the main difference is the storage method as noted earlier.

Here is the model relationships.

From this I am trying to filter using both dimensions as above.
When I use both filters simultaneously I am hitting the error.

I have the same model as import which works, however, it doesn't work using direct query.

Any help would be much appreciated.

Thanks!