cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JakeRyan11 Frequent Visitor
Frequent Visitor

Getting Data from ODBC using SQL statement

I'm receiving this error when I try to use a SQL statement to parse the data by date. (Using ODBC connection)

 

ODBC Error 3.PNG

 

Here's my current SQL Statement: 

 

SELECT fv_v_allocated_time_view_all_modules_lem_filtered.timesheet_fmt_dt, fv_v_allocated_time_view_all_modules_lem_filtered.last_name, fv_v_allocated_time_view_all_modules_lem_filtered.first_name, fv_v_allocated_time_view_all_modules_lem_filtered.skill_type, fv_v_allocated_time_view_all_modules_lem_filtered.rate_1_rate, fv_v_allocated_time_view_all_modules_lem_filtered.project_id, fv_v_allocated_time_view_all_modules_lem_filtered.work_unit_id, fv_v_allocated_time_view_all_modules_lem_filtered.company_code,fv_v_allocated_time_view_all_modules_lem_filtered.employee_or_equipment_id, fv_v_allocated_time_view_all_modules_lem_filtered.equipment_ind, fv_v_allocated_time_view_all_modules_lem_filtered.rate_1_hours, fv_v_allocated_time_view_all_modules_lem_filtered.company_name, fv_v_allocated_time_view_all_modules_lem_filtered.net_billable_time, fv_v_allocated_time_view_all_modules_lem_filtered.last_modified_by, fv_v_allocated_time_view_all_modules_lem_filtered.extra_charges
FROM vdb_track.fv_v_allocated_time_view_all_modules_lem_filtered
WHERE timesheet_fmt_dt > '12/31/2017'

1 ACCEPTED SOLUTION

Accepted Solutions
JakeRyan11 Frequent Visitor
Frequent Visitor

Re: Getting Data from ODBC using SQL statement

The table or view name was too long, so I tried to give it an alias like below:

 

SELECT v.timesheet_fmt_dt

FROM vdb_fv_v_allocated_time_view_all_modules_lem_filtered v

WHERE v.timesheet_fmt_dt > '12/31/2017'

 

This worked for me.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Getting Data from ODBC using SQL statement

Hi JakeRyan11,

You said when you use SQL, it will cause this problem, if you write "select *  from table", will this work ? Or if you don't write sql query, will this work? In addition, I am not sure whether this is caused by sql query or other  factors. And whicy type file you are using in ODBC? And you also could check which step will cause error in Edit Queries.

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

JakeRyan11 Frequent Visitor
Frequent Visitor

Re: Getting Data from ODBC using SQL statement

Thanks dax, 

 

The ODBC is connecting to our data lake through Denodo. 

 

I've added "SELECT * FROM TABLE" but now receive this error: 

ODBC Error 5.PNG

 

If I do not type in the word "TABLE", then it runs this error: 

ODBC Error 6.PNG

JakeRyan11 Frequent Visitor
Frequent Visitor

Re: Getting Data from ODBC using SQL statement

The table or view name was too long, so I tried to give it an alias like below:

 

SELECT v.timesheet_fmt_dt

FROM vdb_fv_v_allocated_time_view_all_modules_lem_filtered v

WHERE v.timesheet_fmt_dt > '12/31/2017'

 

This worked for me.

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors