Limitations to 50 elements with the API

[CyrilN]

Hello,

I'm connected to a database through an API. I can load my 500 records, but when transforming them into a table I only get 50 elements.

How can I manage to get all my records?

Thanks,

Cyril

[v-jingzhang]

Hi @CyrilN 

How did you transform the query? Can you share the M code from Advanced Editor? When you come to the Source step before any transformation step, can you insert a step to count the records there? What is the data type before table transformation?

Best Regards,
Community Support Team _ Jing

[CyrilN]

Hi and thanks for trying to help

Unfotunatly they never show up., even after saving and exiting.

[CyrilN]

And I will add that the report stays with the 50 records only

[amitchandak]

@CyrilN , Data transformation should be able to show a sample for 1000 rows. 

After you save and exit data transformation, are you getting all rows ?