Timout expired trying to connect to Quickbooks generalledger table

[emorrell]

I have a simple query to connect to Quickbooks (QB):

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

Today my refresh failed because of a timeout trying to refresh this QB data. When I open Power BI desktop, the general ledger will try to load indefinitely. The bottom right corner just says "Waiting for Quickbooks". I can load other tables just fine. My credentials in Power BI still work to login into QB online, so the credentials should not be the problem.

Anyone else having a similar issue or have a suggestion? QB support was no help and just said to contact Power BI support.

[emorrell · Accepted solution]

Update #2: Reports are refreshing again. Guessing it was a quickbooks issue that they resolved. Never did anything on my end to fix it, just waited it out.

[emorrell]

Update: I've been able to refresh the general ledger table in Power BI Desktop today. Unlike yesterday, there does seem to be some response from quickbooks. Power BI online refreshes are still failing, but at least this is a temporary work-around.

[rohit1991]

HI @emorrell ,

Jumping in here as I’ve been following this issue pretty closely (and experienced it myself).

If you’re running into timeout errors or endless “Waiting for QuickBooks” messages when connecting to the generalledger table in Power BI, and your other tables are working fine, it’s almost always an issue on the QuickBooks (Intuit) backend, not a Power BI problem or anything wrong on your end.

For large tables like generalledger, try to limit the data you pull at once using filters by date or account, for example if possible. If you need more reliability, consider pulling your QuickBooks data into a database or file and connecting Power BI to that, instead of going direct every time.

This was a QuickBooks backend issue, and all you can really do is wait it out. There’s no fix needed on your side.

[sshivers]

I'm experiencing the same issue. It started suddenly yesterday (March 27th) but was fully operational previously. You can see how everything was working on the screenshot I've included in this post so it shouldn't be a lack of capability or anything along those lines. I have since attempted to filter the data to exclude older years, however, it is still giving the same error. I think there's some sort of issue on the QBO side of things since previously, my tables would be fully updated in around 15 - 30 minutes in the PBI service. For an on demand update yesterday, my refresh failed after a little over 8 hours.

[sshivers]

I'm encountering the same issue. It's only with the generalledger tables unfortunately since all my other various QBO connections are still working and refreshing.

[sc20d]

@emorrell Did you ever resolve this issue? I am experiencing the exact same issue on about the same timeline. 

Connections to QB Online working on scheduled refreshes with no issues for months. Last scheduled refresh that succeeded was Mar 26 @ 5 PM ET. Five subsequent refreshes (a mix of scheduled and manually triggered) refreshes on the service plus refreshes in Desktop all fail after spinning for 2 hours and then timing out. 

I am able to load other tables such as the invoice table with no issues. It looks like this problem is isolated to the general ledger. 

[rajendraongole1]

Hi @emorrell  - Large datasets can lead to timeout errors during refresh operations.can you please refer the below blog  and approach to connect QB

How to Сonnect QuickBooks to Power BI | Coupler.io Blog

Does anyone know why the Power BI online scheduled refresh no longer works? Seems like an authentica...

Hope this helps.

@emorrell

[emorrell]

Hello, I am doing everything correctly according to these rescources you linked. My quickbooks connection was working fine for many months and then stopped working without warning. The issue is specific to the general ledger table. You can see from the other comments that the connection stopped working for others at the same time. Can you suggest anything else?

[sshivers]

I created a ticket on the Intuit developer forum as well. https://help.developer.intuit.com/s/question/0D5TR00000jcr3l0AA/power-bi-connector-refresh-failures

[emorrell]

Great! For some reason I am having trouble seeing your ticket. If you get an answer can you post it here as well?