Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Error in Direct Query !!

HEy,

I tried to implement directquery example by small example but it is giving error that ODBC connection failed when i am fetching data from excel sheet by direct query.

Data3:

DIRECT QUERY

dimension

Month

measure

Value

FROM Example1.xls;

Please tell what to do.

Thanks

3 Replies
tresesco
MVP
MVP

Direct query requires ODBC connection. Learn it from pdf you would find here: What is Direct Query?  What are the advantages?

jagan
Luminary Alumni
Luminary Alumni

Hi Nikhil,

Direct Discovery works on ODBC, It will fetch data from databases only.  So, store this excel file data into database table and create ODBC to the database and then try.

Regards,

Jagan.

nikhilgarg
Specialist II
Specialist II
Author

Hey,

Thanks for information.