Forum Discussion

Ad0m1n's avatar
Ad0m1n
Regular Visitor
6 years ago

Refresh Correlation Coefficient

Hi all,
We have a measure that calculate the correlation coefficient. In the Power BI Desktop this measure is working correctly, but when we refresh the report in the service, the measure lose the values.

 

the code of the measure is:

 

 

When the report is published in the service, the values ​​are correct. The following table show the values.

 

But we refreshing the report, the service shown the same table but the values of the measure correlation coefficient are blank.

 


Is there any solution?

Thank you very much

Need Help

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    That might be the case when there is something in your PBIX after refreshing that is causing the numbers to change.

    Make sure that you do not have any parameters in the Power BI Service?
    • Ad0m1n's avatar
      Ad0m1n
      Regular Visitor
      6 years ago

      hi GilbertQ 

       Thank you very much for the replay, but the pbix  or the service haven't any parameters. 

       

       

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Ad0m1n ,

     

    Can you see the data of Recommendation Num and Value Number column in Power BI Service when put then into a table visual? What connection mode you used in this document? Have you meet this issue in this report before?

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Ad0m1n's avatar
      Ad0m1n
      Regular Visitor
      6 years ago

      Hi v-lid-msft 

       This error ocurr from several months. Also the values ​​are not show in any table visual, it's as if the calculeted measure is not executed. We load data from a sql server database with import option.

       

      Thank al lot.

      • v-lid-msft's avatar
        v-lid-msft
        Community Support
        6 years ago

        Hi Ad0m1n ,

         

        If you miss data after refresh in Power BI Service. Could you please check the refresh history and the connoction status of gateway?

         

        Best regards,

        Community Support Team _ Dong Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Ad0m1n ,

     

    If your issue still does not resolved, we suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

     

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.