Hi,
I am using QV 11.2 SR4 version client. I am trying to use a Direct query to fetch data from an Excel file, by creating a DSN for the excel. The excel file is located in a network path. So my connection string looks something like this,
ODBC CONNECT TO [<DSN Name>;DBQ=\\<server_name>\Example_data.xlsx] (XPassword is ENXWOYFMTbcOXXXXXXA);
I am using a Direct query to fetch a particular field, like below.
DIRECT (Stale After 5 seconds) SELECT Region Implicit Qty
FROM `Sales$`;
In the UI, I have created a bar chart with Region as Dimension and expression as Sum(Qty). Now, the chart displays data only when the excel file is opened manually. Else, the chart just displays an error message "Direct Query Failed".
Can anyone please help me to identify the error in this case?
-Regards,
Mithun