not showing all the data even tough it shows it all in the preview table

[#1]

help!

i have some strange problem

i try to show a simple view table i did in SQL and it looks good in the SQL and in the QV at the preview window

but when i try to see it in the sheet it shows only 4 rows... can't figure out why...

any ideas?

thanks

[#2]

Hey Asaf, do check your model....way too many joins. See if you can reduce them. Fine tuning the model will help a lot here.