Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Direct query requires ODBC connection. Learn it from pdf you would find here: What is Direct Query? What are the advantages?
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.
Hey,
Thanks for information.