Direct Discovery with MS SQL Views - Direct query failed

[Anonymous]

Hello,

I have some problems with Direct Discovery. We use QlikVew 11.2 SR10 with MS SQL 2008 R2 and publish the Apps on AccessPoint.

Direct Discovery works only if it access to sql tables directly or views with one table. If I use joins in views I get an error "direct query failed".

In addition is Direct Discovery very selektiv with sql view formats. Not all formats will be accepted.

With Views, which contain another views, doesn't work direct discovery too. Always error "direct query failed".

Has anyone expirienced this?

P.S. In Desktop works all, the problem is with AccessPoint only.

[Anonymous · Accepted solution]

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.