Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
alau020
Frequent Visitor

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

 

Preview is Evaluating.PNG

 

Error Message.PNG

1 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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.
1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Lydia.

The SQL code I have used worked.

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.