Forum Discussion

JackEnviro's avatar
JackEnviro
Icon for Helper I rankHelper I
8 years ago

Connect large data table with ODBC (CData ODBC connecter)

Hi All

 

I'm trying to create somes reports in PowerBI from Zoho using the CData Zoho ODBC driver. I belive a key table I require is the StageHistories table. However when I try to connect directly I get the error shown below.

 

I've tried running a direct SQL query and can return the first 100 rows but not sure how to bring more data through.

 

I've also tried running a query against StageHistories and a table I think we require LinkingModule2 but I'm having trouble querying against the LinkingModule2 table (although I can connect directly)

 

Any help on the best way to connect much appreciated!

 

Thanks

Jack

 

 

 

 

Need Help
Tutorial Requests

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    JackEnviro,

    Please input your SQL statement in the highlighted textbox to get required columns and rows, then check if you can get data from StageHistories table.




    Regards,
    Lydia

    • JackEnviro's avatar
      JackEnviro
      Icon for Helper I rankHelper I
      8 years ago

      Hi Lydia,

       

      The SQL statement I'm running to get the data is as follows:

       

       SELECT TOP 100 * FROM StageHistories

       

      This successfully returns the first 100 rows, but the problem is when I try to retrieve every row in this table. It only returns an error message (after some loading time); "429 Too Many Requests".

       

      Thanks for the help

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        JackEnviro,

        The error could be caused by the large size of the table. Are you able to input the SQL statement into highlighted textbox to get data?

        Regards,
        Lydia