cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ad0m1n Frequent Visitor
Frequent 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
Super User
Super User

Re: Refresh Correlation Coefficient

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 Datanaut!"
Power BI Blog
Community Support Team
Community Support Team

Re: Refresh Correlation Coefficient

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.
Ad0m1n Frequent Visitor
Frequent Visitor

Re: Refresh Correlation Coefficient

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.

Ad0m1n Frequent Visitor
Frequent Visitor

Re: Refresh Correlation Coefficient

hi @GilbertQ 

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

 

 

Highlighted
Community Support Team
Community Support Team

Re: Refresh Correlation Coefficient

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

Re: Refresh Correlation Coefficient

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.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 455 members 4,087 guests
Please welcome our newest community members: