I am currently using QuickBooks Online Connector to link to PowerBi. One of our data entry inputs is through "Batch Transactions". I am trying to find the table for this

Let's work together in locating the data posted through batch transactions, kayman.

First, I'd like to confirm if you're referring to data posted in QuickBooks Online (QBO) through Reclassify Transaction. However, if you're talking about the data reflected in PowerBi, I suggest going to their designated forum to ask for assistance.

Furthermore, I'll add this resource to help keep your accounts, customers, and vendors organized: Merge duplicate accounts, customers, and vendors in QuickBooks Online.

Hit the reply button below if you have other questions about moving multiple transactions. I'll always be around to assist you. Have a nice day!

Hello Camelle, sorry but that's not what I am looking for.

When you open PowerBI and go to get data > Other sources > QuickBooks Online (Beta), a list of data tables is shown such as Bill Payment, Journal Entry, Bills, Account etc. 

What I am saying is that QuickBooks is showing that the transaction is in a "Check" table, but in the list of data tables, there is no "Check" table. We also tried searching for the ID in all the other data tables but it is not there.

So where is this data stored?

Hello Camelle, this is not what i am looking for.

When you open PowerBi > Get Data > Other > QuickBooks Online (Beta), several data tables is shown and you can select which data tables you need (essentially, every transaction in QuickBooks belongs to a data table)

For this query, the transaction in QuickBooks shows that is is stored in the "Check" table, but from the list of tables available "Check" is not one of them. There are tables such as Bills, Bill Payment, Journal Entry, Deposit, Account etc.

We also tried using the data ID and search for it in all the other tables, but it's not there.

So where exactly is the "Check" table data stored?

I appreciate you for getting back to us, @kayman-singh-etk.

I understand how important it is when linking QuickBooks to PowerBi. Let me assist you get the support you need and help you fix this.

We have a separate forum where you can interact with Power BI developers and software engineers about their products. I recommend posting your concerns on their forum, as they can address your questions best. You can post your concern through this link: https://community.powerbi.com.

 
Feel free to explore this article for insights on customizing your reports: Common custom reports in QuickBooks Online.

Please ping me if you have additional concerns when managing QuickBooks data. I'm all ears to help you.