Table only showing 2000 rows

[Stavros2024]

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 attributes, and removing unused columns, the final row count is 2000 and ends up being the same in the reports.  Is there a hard limit set somewhere for table rows? I couldn't find anything in my settings or search engines.  None of the steps seem to limit the rows, they are just the defaults

[ReportRanger]

Hi @Stavros2024 You may be using the SF reports connector which has this limitation of 2k rows. As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls data directly from the SF objects API. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[Anonymous · Accepted solution]

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]

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

[daircom]

@Stavros2024 , 
Is it possible that you see 2000 rows in the query editor? As there is a hard limit on the rows you can see in the query editor. What I would do is go to the the visualisations tab and create a simple measure:

Measure = COUNTROWS(Table)
If you move this measure into a card visual, do you still see 2000 rows? If you see 3322, then Power BI does import all your rows. 

[Stavros2024]

Hi @daircom I did exactly that, added a measure with countrows, still 2000

[FlipFlop1]

Power Query opens in preview mode, so it doesn't display all the rows. If you close and apply, you can check the number of rows when it is loaded as a table.

[Stavros2024]

Thanks @FlipFlop1, I've done that too, I did that before creating the measure above to count rows