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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ThiagoDuarte
Helper I
Helper I

Wrong value after refreshing on service

Hello,

 

My report works fine on desktop and i can update it and still get the right results, but when after publishing it, at first i get the right values but if i update the dataset via service I get wrong values afterwards

 

1. Desktop

ThiagoDuarte_1-1670238333409.png

 

2. Service (after publishing):

ThiagoDuarte_2-1670238359533.png

 

3. Service after refreshing (refresh on service)

ThiagoDuarte_3-1670238552986.png

 

  • My report is in premium capacity
  • I've tried refreshing the browser, cleaning history and cache and a few diferent browsers
  • I've tried deleting and republishing. It works but after refreshing on service I get the same error
  • I need the refresh to be fully automated (every couple hours)

 

Some information about the data:

  • There's a table called reportexperience in which there are a few columns with the lead time (for each part - there are a lot of them) for each sector of production (for each part all the information is in the same row and it has no sector id column)
  • Each lead time is a calculated column
  • There's a table with each sector and it is not related to the first one
  • The measure showed in the graph is as follows:
lead_medio = 
var setorid = MAX(Setor[setor_id])
return
SWITCH(TRUE(),
setorid=1,AVERAGE(reportexperience[lead_moldagem]),
setorid=2,AVERAGE(reportexperience[lead_revisão]),
setorid=3,AVERAGE(reportexperience[lead_vazamento]),
setorid=4,AVERAGE(reportexperience[lead_desmoldagem]),
setorid=5,AVERAGE(reportexperience[lead_quebra]),
setorid=6,AVERAGE(reportexperience[lead_toto]),
setorid=7,AVERAGE(reportexperience[lead_qc]),
setorid=8,AVERAGE(reportexperience[lead_eng]),
setorid=10,AVERAGE(reportexperience[lead_total])
)

 

I'm trying to use the sector table as a index for x axis and calculate the average lead time (based on the reportexperience table)

Does anyone know what might be happening and how to fix it?

 

Thanks,

Thiago Duarte

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @ThiagoDuarte 

 

Please refer to the following links in the hopes of helping you.
Solved: Measures Breaking on Refresh - Microsoft Power BI Community

Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community

Solved: SUMX DAX measure value loads blank after refresh i... - Microsoft Power BI Community

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @ThiagoDuarte 

 

Please refer to the following links in the hopes of helping you.
Solved: Measures Breaking on Refresh - Microsoft Power BI Community

Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community

Solved: SUMX DAX measure value loads blank after refresh i... - Microsoft Power BI Community

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you @v-zhangti 

 

This solved it for me:

Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community

 

I had and aggregation in power query with data type as alphanumeric. I just changed it to date time and it worked

 

Best regards,

Thiago Duarte

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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