Forum Discussion

CyrilN's avatar
CyrilN
New Member
4 years ago

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

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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 ?

  • CyrilN's avatar
    CyrilN
    New Member
    4 years ago

    Hi and thanks for trying to help

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

     

    • CyrilN's avatar
      CyrilN
      New Member
      4 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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