Hi Chrissy! If I remember correctly, were you the one that had another issue with extracts maybe a month ago? If so, did you solve that issue?
Are you sure you're not including any data source filters or extract filters? I tried opening your packaged workbook, but you'll need to extract the data source before packaging it in order for it to properly be stored inside the package.
It's very likely that you remember me from another extract question. We've been struggling with appending data and connecting with ODBC... We're muddling thru!
I've reattached the workbook here with the extract. I'm certain I'm not applying any filters to the extract. I simply right-click the data source, click Extract Data and then click OK. But, I'd be happy to be proven wrong on this if it means I can use the data!
Thanks for your help,
Bad Extract.twbx 44.0 KB
I don't have access to the Data Source tab from your attached workbook as it's saying I would need to connect through the ODBC.
What i wanted to check was: When you click the Data Source tab and bring in your data to the data window (after doing all necessary joins) did you click the "extract" tab and not "live"?
It seems so simple but I've missed this multiple times and makes a difference.
Hope that helps!
It's been a while, but to answer your question.
I've tried it several ways. I connect to the data, then go to a sheet and drag number of records to the view. I see 13,000. Then I right-click the data source in the upper-left corner and select Extract Data. I don't add any filters, just click okay. And once the extract is created, I suddenly have 700 records.
Or, I click Extract on the Data Source tab (as you've shown above). Again, I apply no filters, not to the live connection or to the extract. There are simply no filters happening here. But, when I'm switched to the extract, I experience data loss.
Any other ideas? I'm experiencing this issue again.
Here's an update. It's been about 4 months since the original post and I'm having the issue again with a different data set (several different data sets in fact). I connect to the data source with a live connection, go to sheet 1, drag number of records to the view. I have 24000 records. I right-click the data source, select Extract Data and click okay. There are no filters applied, not to the live connection, not on the extract. There are simply no filters, here. When I'm switched to the extract, I end up with 11000 records.
What I've noticed, however, is that if I unjoin the tables, and extract data from individual tables, there's no data loss. I'm using a left join so there's no reason the join should eliminate data.
Next, I tried converting my data source to SQL. Same issue: Live connection is good to go, extract loses data.
I've opened a support ticket with Tableau, but I'm hoping someone here might have a solution? Or just anything I can try? I'll try anything!