Error in Direct Query !!

[nikhilgarg]

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

[tresesco]

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

[jagan]

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]

Hey,

Thanks for information.