Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
22 | |
22 | |
20 | |
19 |
User | Count |
---|---|
46 | |
21 | |
20 | |
19 | |
18 |