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
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Hey Wilson, 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
Ive been fiddling with the new QB Connector, but am stumbling into some issues. I'd love to use the pre-built P&L Dashboard to help diagnose the issue, but I do not see it on the Pre-release site. Do you know if there is any other way to get a hold of it?
Hey Wilson. Sorry, my mistake. :-( I accidentally announced a new feature before it was released, the pre-built dashboards aren't yet available. However, I've found a way to share an early version of the P&L, we'll be posting it on the pre-release site shortly, stay tuned for updates.
Any chance you could share any pre-built reports
I connected this AM and to test without the reports is nearly impossible
Like the fact that there are so many more tables than prior connector