Forum Discussion

alau020's avatar
alau020
Frequent Visitor
8 years ago
Solved

ODBC connection - large table

Hello,

 

I am trying to connect to a Jade database via an ODBC connection. I can see the tables (as per below) but when i select the individual table "JCJob" as per below, preview is evaluating does not produce anything. This is a large database with over 8000 tables.  I am using Power Bi Desktop. Any ideas?

 

Thanks

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    alau020,

    Glad to hear that issue is solved, you can accept helpful reply as answer, this way, other community members can easily found this solution when they  get same issues.

    Regards,
    Lydia

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    alau020,


    How many columns and rows in this large table? Please select required columns and rows through SQL statement and then check if you can successfully load data.


    Regards,
    Lydia

    • alau020's avatar
      alau020
      Frequent Visitor
      8 years ago

      Thank you Lydia.

      The SQL code I have used worked.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        alau020,

        Glad to hear that issue is solved, you can accept helpful reply as answer, this way, other community members can easily found this solution when they  get same issues.

        Regards,
        Lydia