Forum Discussion

Stavros2024's avatar
Stavros2024
Regular Visitor
1 year ago
Solved

Table only showing 2000 rows

Hi everyone, I've got a JSON file which I know has 3322 records Screenshot of source step  once it has gone through all the other steps - convert to table, expanding records, expanding record...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Stavros2024 ,

 

What kind of connectors are you using? 2000 is more like a limitation, e.g. the api is set to return only 2000 records at a time.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

  • Stavros2024's avatar
    Stavros2024
    Regular Visitor
    1 year ago

    Thanks Anonymous, yep using the Salesforce REST API call, which is limited to 2000 rows.  FYI you can get around this by using the Bulk API V2 call