I have a question regarding data source filter. Let's say in the DB there 2M rows of data and when I filter this by using data source filter, it gives me 12K rows. Now, I want to understand how Tableau works here? Whether Tableau brings in all the data(2M rows) and then apply the filter or vice-versa. As Tableau is taking 30-40 mins to load the view, so I guess it brings in all the data and then apply filter. I am using live connection to MS SQL server.
Is this correct? I am using live connection to MS SQL server.