Quickbooks Online connector doesn't show all data

[nanci]

I'm using the Quickbooks connector to get data in PowerBI desktop.
The issue is that the data for some accounts is missing. This issue started suddenly this week.
I get data from the GeneralLedger table.

I don't know how to fix this because the data is correct in Quickbooks and arrives incomplete in PowerBI so it seems to be a problem with the connector.

[v-kelly-msft]

Hi @nanci ，

Check the similar thread below:

https://community.powerbi.com/t5/Desktop/QuickBooks-Online-PowerBI-New-Connecter-and-New-Data-Table/...

Here is the reference about getting data from quickbooks online,be sure that you have uploaded all the data you need.

https://docs.microsoft.com/en-us/power-bi/service-connect-to-quickbooks-online

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[nanci]

Thanks for the links.

So, in another thread, someone from Microsoft Support mentions that PowerBI supports 2 connectors for Quickbooks. In the new connector the General Ledger table is not available so because I need this table I'll keep using the old connector.
The issue then is that the old connector is not delivering the last rows in the GeneralLedger table. It is like there is a limit in the number of rows or cells. Where can I find what the limit is? or is this an error?

[v-kelly-msft]

Hi @nanci ，

You can refer to the following references:

http://newqbo.com/quickbooks-online-file-size-and-feature-limits/

https://quickbooks.intuit.com/learn-support/en-us/manage-lists/maximum-number-of-list-entries-list-l...

https://www.intuitiveaccountant.com/general-ledger/quickbooks-online-usage-limits-did-you-know/#.Xnx...

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!