Forum Discussion
Quickbooks Online (QBO) connector - Journal tables missing data
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!
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,
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.
2 Replies
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,
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.
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.
