Quick book connector not importing all the data

[Junaid11]

I wanted to show trial balance report in Power BI from Quick book connection but Quick book is either not importing all the data or whether I am doing something wrong. I imported Accounts table from Quick book and I had current balance column in it. I split that column based on - through which I got Debit and credit but I did not find the balance values between both columns. I checked and found out few of my columns were showing 0 as current balance while I checked and found out the actual Trial balance has value against Retained earning. kindly help meimport exact data from Quick book. Pictures are attached.

Actual Retained earning value

Value imported in Power BI

Thank you.

[v-zhangti]

Hi, @Junaid11 

Sorry, I can't reproduce this issue. You can search for similar issues here.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.