Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

No data loaded from SQL Server Stored Procedure

Good morning everyone,

I am new to Qlik and I am in a learning phase.

I connected Qlik Sense to a SQL Server 2014 instance and I was able to populate two Tables in the Data Manager with data from views in the DB.

Then I created, trough a script, a table that should get data from a stored procedure.

This is the script I'm using:

Capture.PNG

When I load the data, the SP called seemed to work, since it founds exactly the rows I expect:

Capture.PNG

Despite of this, the table in the Data Manager is empty after any "Load data":

Capture.PNG

The other tables, which retrieve data from DB Views, are correctly populated with data.

Could someone please provide me with help in understanding what is wrong in what I am doing?

Thank you

PS: I tried using a connection string created with the OLE DB Connector and with another one created with the ODBC Connector, the result is the same.

0 Replies