Forum Discussion

SJi's avatar
SJi
Frequent Visitor
8 years ago

KPI returns null but procedure numeric value

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

KPI
Report Server

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    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