Quickbooks Online (QBO) connector - Journal tables missing data

[EGreeff]

I am building some basic reports in Power BI for a client based on data from Quickbooks Online.

I am connecting to their data via the Quickbooks Online connector in Power Query. Most of the tables are pulling through fine, but all of the journal tables are empty:

The client does have journal entries which reflect in the reports pulled directly from the QBO frontend. 

I have admin access (otherwise the connector would not work at all). Could the issue possibly be the type of admin access I have? Anything else I can troubleshoot? I'd appreciate any advice.

Thanks!

[EGreeff]

Thanks for the reply! It turns out it was my level of access. The client increased my access level and now the journal tables are pulling through correctly.

I'm not sure what my exact access rights were previosuly and what they are now, otherwise I would post them here for the next person who might struggle with this issue. But for now at least it is resolved.

[v-xinruzhu-msft · Accepted solution]

Hi @EGreeff 

Based on your descriotion, please make sure you have the full control of the permission, you can refer to the following link about it,

QuickBooks Enterprise: Manage user permisions - Experts in QuickBooks - Consulting & QuickBooks Trai...

And you can refer to the following link

Connection to QuickBooks shows empty tables - Microsoft Fabric Community

Best Regards!

Yolo Zhu

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