Forum Discussion
Visual shows blank row when in Direct Query mode
It is the expected behavior. If you don't include a column of the fact table, the only way to avoid the blank row is to join the fact table - which could be expensive. So the assumption is that there could be a blank row if you didn't specify "assume referential integrity" - checking the presence of the blank for every query on the dimension would be extremely expensive. DirectQuery is already slow enough this way.
It is the expected behavior. If you don't include a column of the fact table, the only way to avoid the blank row is to join the fact table - which could be expensive. So the assumption is that there could be a blank row if you didn't specify "assume referential integrity" - checking the presence of the blank for every query on the dimension would be extremely expensive. DirectQuery is already slow enough this way.
Hi Marco, thank your for your reply.
I will consider it behavior by design then.
I have to note that the blank row does not appear when I remove the relationship between the dual storage mode dimension and the Import storage mode fact table. But doing so (and altering my model consequently) would defeat the purpose of the Dual storage mode I guess.
So the other remaining options are not using the option 'Show items with no data' or accepting that a blank row appears when using it.
