ODBC connection - large table

[alau020]

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

[v-yuezhe-msft]

@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]

Thank you Lydia.

The SQL code I have used worked.

[v-yuezhe-msft · Accepted solution]

@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

[acarolli]

Hello,
okay?

I need to insert two dates in SQL Statement with the following format '' DD-MM-YY '', 'DD-MM-YY' ", one being the current date (today) and the other 30 days ago.

how can I do this?