Place your sql query in Tableau custom sql window and check if Tableau is pulling in the data. If it does, then joins in your 1st method is likely causing the issue.
Thanks for the reply. Now data is coming.
Problem is when I am getting one column from Fact 2 and Dim 1 then my records are not matching (Since all tables are coming in SQL. like Fact 1 and their respective joined tables as well).
Any specific design method for handling this?