Execute stored procedure in qliksense

[govardhana_r]

I am trying to execute a procedure to pull the data to qliksense however I am unable to connect. I get the below error

Load
*;
SQL EXEC qlik.sp_getTestData;

However the procedure exists in the DB and I am getting results when running from the SSMS

[Vegar]

Are you able to load a normal table from that database?

How does the FROM ... look like when you do that?

Could  it be that your missing important info in your FROM adress? Like dbo. or something else?

Load
*;
SQL EXEC qlik.dbo.sp_getTestData;

Make also sure that you are connected to the correct Qlik DataConnection, so that you don't  try to run on the wrong database server.

[govardhana_r]

Thanks Vegar. I had to add Database name to the query and then it worked

dbname.qlik.sp_getTestData