Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
2. Service (after publishing):
3. Service after refreshing (refresh on service)
Some information about the data:
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
Solved! Go to Solution.
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.
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