Where are you finding the row count from the data in Tableau? Are you looking at the preview on the Data Source Tab?
Or from the Number of Records in the measures (or some other means)? I believe the Data Source Preview is limited to 10,000 records for performance reasons, but number of records will give you an accurate representation of the data source.
I got the number from the measure number of records, but it turns out I was connected to our test database rather than our production one so that is where the issue lied. Thank you for your help. Also, just so you know, you can input the number of records that you want to see in the preview which will allow you to exceed the 10,000.
Thank you for your help.