topic KPI returns null but procedure numeric value in Report Server

KPI returns null but procedure numeric value

SJi — Tue, 30 Jan 2018 13:16:36 GMT

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

Re: KPI returns null but procedure numeric value

v-qiuyu-msft — Fri, 02 Feb 2018 02:16:11 GMT

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