# Missing Transactions in Power BI Data Model with QuickBooks Online Connector **URL:** \ **Category:** CData Drivers\ **Tags:** question, driver, power-bi, odbc, connector\ **Created:** [November 18, 2024, 3:55pm UTC](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943 "2024-11-18T15:55:17Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Shakil](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@Shakil](https://community.cdata.com/u/Shakil)\ **Post date:** [November 18, 2024, 3:55pm UTC](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943/1 "2024-11-18T15:55:18Z")
I created a Power BI data model using the QuickBooks Online connector and successfully built some basic reports. However, I noticed that certain transactions are missing from the data. I queried all available tables but couldn’t locate these transactions. Interestingly, when I used the ‘TransactionsList’ stored procedure, I was able to retrieve all transactions, including the missing ones. I suspect that some transaction types, such as Payroll Checks, may not be accessible through the CData connector or Intuit Accounting API. Has anyone else encountered this issue? Is there a known limitation or a workaround to include these transaction types in the data model? ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [November 20, 2024, 5:55pm UTC](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943/2 "2024-11-20T17:55:10Z")
Hi ​ @Shakil , Based on your description it sounds like you are looking for a table that would return Payroll Checks transactions directly. If that is the case you will not be able to accomplish that unfortunately, as your assumption is correct. Indeed, the Accounting API does not support this and since our connector is build upon the API we do not support a way to retrieve those transactions either. You can read more here: > **[Intuit Developer Support](https://help.developer.intuit.com/s/question/0D54R00009NYXC3SAP/how-can-we-access-payroll-checks-via-the-api)** On the other hand, the TransactionListReport is a view that is created by making use of the CreateTransactionListReport stored procedure which is based on the reporting endpoint and allows you to get a list of all the transactions. The supported transaction types are defined in the help docs section: [CData ADO.NET Provider for QuickBooks Online - CreateTransactionListReport](https://cdn.cdata.com/help/RNK/ado/pg_sp-createtransactionlistreport.htm) In case you are missing any other transactions apart from Payroll Checks, kindly provide more information on those. Feel free to reach out to our support team at [support@cdata.com](mailto:support@cdata.com) if you have any other questions or if you need further instance with our products. ---
**Author:** ![Shakil](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@Shakil](https://community.cdata.com/u/Shakil)\ **Post date:** [November 20, 2024, 6:01pm UTC](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943/3 "2024-11-20T18:01:59Z")
Thanks for the reply.