Can you help me to close this thread by marking correct. it might useful for others who is having similar issue.
i saw the video but actually the problem is not solved because i could fetch the data by executing Stored Procedure but i could not see where are the data ??
I am uploading two screenshots; I have an empty MS SQL Server Express database, its table: Users contains 3 records, so I used it to create the store procedure that illustrate how Qlik Sense load data from MS Sql Server Stored Procedures:
This is my data connection; I am using a SYSTEM DSN based on the ODBC Data Source Administrator (32-bits)
Now this is the script; note: I loaded the User table just to get Qlik Sense to tell me how to reach the object (table, procedure or view) at the database.
You should have a LIB CONNECT TO ... ; very similar to the one shown below.
The main difference is with the SQL EXECUTE, here I had to spell the database name: "ReportServer$SQLEXPRESS2008R2" followed by the name of the stored procedure: dbo.List_Users
My test was using: StandardReload=0;
My second test without StandardReload, worked fine as well.
Your DSN name not found. refer to the attachment for the DSN and import stored procedure from SQL server. Thanks
from your screen shot i can see one more DSN call "sqlserver" can you try with that.
LIB CONNECT TO 'sqlserver';
SQL exec dbo.Students;
as you said i used sqlserver DSN and i rename it to sqlserver1
now the data has been fetched and true result is 5 records
but where can i find the data to start make some visualization