Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

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.

Tags (1)
Community Browser