One tableau report designed by some other people and it was fetching only 9 records in tableau. When I ran that query in backend sql server it is fetching more than 100+ records. I have used same filters what used in tableau. but still the same record count. I didn't find any problem in tableau query. can anyone help me
Where do you see those "9 records"?
Can you show a screenshot of Data Source tab?