Hi @taranr_sockeye,
A support ticket has been initiated through [email protected], and the case is currently under investigation and being addressed.
Sweet, can you share here when the investigation is concluded?
Also, still curious for the larger community what sort of numbers they’re seeing?
I use automatic refresh in Power BI because mine takes awhile. I even split up my query in to two parts based on the modified date and then merge them in Power BI. This allows me to refresh a smaller portion of the GL Detail table every day. However, I’ve been trying to update the “static” query since yesterday and it just gets stuck on “evaluating” for hours and eventually errors out.
Thought I’d share my results at the end of my research:
Cdata Sage Intacct Power BI connector, testing on querying a Gldetail of 1.5 M rows.
- 150-250k rows per hour
- Limiting the number of columns from 92 to 50 did not speed up performance (was within the range).
I believe the speed is likely due to the time of day and traffic on Intacct’s side, but that’s unclear.