Question
General Ledger table does not load in Power BI
I have been loading in the general ledger table for a long time using the query:
let
Source = QuickBooks.Tables(),
generalledger = Source{[Key="generalledger"]}[Data]
in
generalledger
Suddenly it no longer works this week. I can load all the other tables using this connection, but not the general ledger. Power BI just says, "waiting for Quickbooks" until an eventual timeout hours later. I posted on Power BI support and found that others started experiencing the same issue as me at the same time: https://community.fabric.microsoft.com/t5/Desktop/Timout-expired-trying-to-connect-to-Quickbooks-generalledger/m-p/4628145#M1385142
Why is the QB general ledger data inaccessible now?