Pulling data from Birst - 100K record limitation?

[Anonymous]

Hi there,

I finally got the PBi to Birst connection to work with lots of help from our IT group.  Problem is now that when i want to pull the data if i try to pull more than 100k records i get the below.

is there a max records for queries within PowerBi?  I thought this wasn't the case, is this some kind of setting we can fix?

[v-piga-msft]

Hi @Anonymous ,

Which connector with getting data from Birst in power bi? ODBC or web API?

Based on the error messager, you have more than 100k rows of data. Please reduce the data and try again if you could load the Birst data successfully in power bi.

Best Regards,

Cherry

[Anonymous]

Hi there,

Thanks for responding.  I am using Birst ODBC 32 bit connection.  I am able to pull less than 100K records but i want to pull much more than 100k records.  Is there some setting on PowerBi desktop that I need to change?

[d_gosbell · Accepted solution]

---

@Anonymous wrote:

I am able to pull less than 100K records but i want to pull much more than 100k records.  Is there some setting on PowerBi desktop that I need to change?

---

This error appears to be coming from Birst, not PowerBI. You'll need to see if you can change this on the Birst side of things.