I noticed a strange behavior when using Direct Query with SQL Server and Dual Storage mode. When a table contains a text-field that a has value with additional space at the end of it, Dual Storage...
SoltV
Advocate I
Advocate IHi v-yuta-msft
What you saw is true, but the problem is visible on the report. Sorry for using the term table like this, I meant table-visual (the problem is visible in other visuals as well, I used the table-visual in this example).
On the report itself, there are two table-visuals. The top one shows only one row when dimTable is in Dual Mode:
But when changed to Direct Query, the same table-visual contains two rows (this is what the table-visual should always look like):