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...
v-yuta-msft
Community Support
Community SupportSoltV ,
I have made a test on your issue. But the result is different from your description. In dual storage mode, the handle is normal(The two rows can be viewed) like below:
However in direct query mode, the data can't be seen.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.