# Cdata: PowerBI + Sage Intacct Performance

**URL:** <https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605>\
**Category:** CData Drivers\
**Tags:** question, power-bi, odbc, sage-intacct\
**Created:** [January 23, 2024, 5:24pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605 "2024-01-23T17:24:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![taranr\_sockeye](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/taranr_sockeye/32/1728_2.png) [@taranr\_sockeye](https://community.cdata.com/u/taranr_sockeye)\
**Post date:** [January 23, 2024, 5:24pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605/1 "2024-01-23T17:24:08Z")

</div>

Hi!

Two pronged question.

1. What’s typical performance that should be expected with Cdata’s Sage Intacct / Power BI connector? [I’m getting about 250k rows loaded from a large data set in an hour]

2. Are there any tricks / tips to enable faster load times for large data sets?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Luçjano\_Capo](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lu%C3%A7jano_capo/32/1638_2.png) [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\
**Post date:** [January 24, 2024, 10:42am UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605/2 "2024-01-24T10:42:49Z")

</div>

Hi @taranr_sockeye ,

A support ticket has been initiated through [support@cdata.com](mailto:support@cdata.com), and the case is currently under investigation and being addressed.

---

<div class="post-metadata">

**Author:** ![taranr\_sockeye](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/taranr_sockeye/32/1728_2.png) [@taranr\_sockeye](https://community.cdata.com/u/taranr_sockeye)\
**Post date:** [January 24, 2024, 4:44pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605/3 "2024-01-24T16:44:33Z")

</div>

Sweet, can you share here when the investigation is concluded?

Also, still curious for the larger community what sort of numbers they’re seeing?

---

<div class="post-metadata">

**Author:** ![Nathan\_Thompson](https://avatars.discourse-cdn.com/v4/letter/n/bbe5ce/32.png) [@Nathan\_Thompson](https://community.cdata.com/u/Nathan_Thompson)\
**Post date:** [January 25, 2024, 9:40pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605/4 "2024-01-25T21:40:39Z")

</div>

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&nbsp;stuck on “evaluating” for hours and eventually errors out.

---

<div class="post-metadata">

**Author:** ![taranr\_sockeye](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/taranr_sockeye/32/1728_2.png) [@taranr\_sockeye](https://community.cdata.com/u/taranr_sockeye)\
**Post date:** [February 5, 2024, 8:24pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605/5 "2024-02-05T20:24:14Z")

</div>

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.