I just actually noticed that next to each of the datasources that are linked to our datawarehouse, the word "Extract" is showing. Is there a way to fix this so it's not pointing to an extract but instead is just pointing to our datawarehouse instead? I'm sure this is why the refresh is NOT pulling in the new rows, but not sure how to fix.
Heidi - it sounds like you or someone on your team may have inadvertently (or on purpose) created an in-memory extract against your data sources.These are often used improve performance agaisnt slow databases.You can read about them in help.
An extract stays static until you refresh it, at which point it is rebuilt and any new rows in your datasource show up.
Here's a data source without an extract. Notice only one "container":
And here's the same data source with an extract active on it note multiple "containers":
You can refresh the extract by right-clicking the data source, choosing Extract, then Refresh:
Note that you can also Remove the extract from same menu. Before doing so, check with your team - someone probably put it there for a reason
Finally, you can tell the data source to connect "Live" to the data source again by deslecting the check mark next to the Use Extract menu item.
Hope this helps!