KPI returns null but procedure numeric value

[SJi]

Hello,

I've created a stored procedure which returns a numeric value, buth both dataset in data preview at server (not in Visual Studio) and kpi return null.

Please, see the printscreen below

[v-qiuyu-msft]

Hi @SJi,

Please go to the shared dataset KPI_Active_CA_Rate, click Load Data to see if data loaded. 

If not, please open the shared dataset in report builder, execute the stored procedure to see if results returned. 

Best Regards,
Qiuyun Yu