Skip to main content
E
emorrell
March 28, 2025
Question

Quickbooks general ledger table does not load in Power BI

  • March 28, 2025
  • 1 reply
  • 0 views

My Power BI report has been connected to quickbooks and pulling in the general ledger table for many months now. This is the query I use:

let
Source = QuickBooks.Tables(),
generalledger = Source{[Key="generalledger"]}[Data]
in
generalledger

 

Yesterday, Power BI stopped being able to load the general ledger table, although other quickbooks tables can be loaded. When trying to load the general ledger table, I get the message, "waiting for Quickbooks" indefinitely until I get a timeout a few hours later. I posted a ticket for Power BI support and learned that others are having the same issue that started at the same time: https://community.fabric.microsoft.com/t5/Desktop/Timout-expired-trying-to-connect-to-Quickbooks-generalledger/td-p/4628145

Why can't quickbooks return the general ledger table anymore?

1 reply

R
Rusimyhr
March 28, 2025

Hi, @emorrell.

 

One of our colleagues has already provided a recommendation for your inquiry, which you can find in this matching post. Feel free to check it out if you’d like to revisit it: https://quickbooks.intuit.com/learn-support/en-us/other-questions/re-general-ledger-table-does-not-load-in-power-bi/01/1539923/highlight/true#M175927. I encourage you to review it for valuable insights.

 

When managing a general ledger in QuickBooks Online, customizing reports is essential for aligning your financial information with your specific business needs. For detailed guidance on how to do this, you can refer to the article: Customize reports in QuickBooks Online. This resource offers step-by-step instructions on how to modify existing reports or create new ones that better reflect your financial data.

 

In addition to customizing reports, you may find the need to export these reports for further analysis or sharing purposes. The article Export your QuickBooks Online data explains how you can easily export your reports and save them in Excel format. This can be particularly useful for those who wish to perform additional calculations or create presentations with the data.

 

If you have any further inquiries regarding the reports or need clarification on any specific points, please don’t hesitate to get in touch with us. We are more than happy to assist you and provide any additional information you might need.

Terms & ConditionsAccessibility statement