Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ad0m1n
Regular Visitor

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:

 

measure.PNG

 

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

 

Captura.PNG

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

 

Captura.PNG


Is there any solution?

Thank you very much

6 REPLIES 6
v-lid-msft
Community Support
Community Support

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/

 

Support Ticket .gif

 

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.

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
Community Support
Community Support

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.

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.

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.

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.

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.
GilbertQ
Super User
Super User

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

hi @GilbertQ 

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors