Does refreshing the QuickBooks Online extract allow for the data to populate as expected in Tableau?
See here for more information on refreshing an extract: Refresh Extracts
If that does not allow for the missing values to appear, does recreating an extract from scratch in a brand new workbook allow for the values to appear as expected?
Reviewing some information on QuickBooks Online, I found the below:
Currently Tableau Desktop leverages data from the following tables in building the the dataview templates:
As potential workarounds:
Mirror the data table onto another supported data source such as Excel. For more options see: All Technical Specifications | Tableau Software
Create an ODBC
Hey Adam, I believe the behavior you're seeing is caused by limitations of the current connector. I wanted you to be aware we're working on a brand-new, significantly improved version of this connector and would love to see your feedback.
Please see: Tableau Data Connectivity Pre-Release
I would also like to highlight the pre-built content we've created along with the connector, also in beta, that recreates the P&L among other things. This is available at the above link too. Note that we're still finding and fixing issues so it's not perfect yet but we're fixing problems as fast as we find them. Please give it a try and let us know if there's anything we missed.
Product Manager - Cloud