Forum Discussion
Limitations to 50 elements with the API
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...
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