Forum Discussion
Different values between the calculated measure in Desktop and in the Service
I have a calculated measure that was created in PBI Desktop and calculates correctly, but after publishing to the Service, when I refresh, a different incorrect value appears. What could be done to resolve this? In this file, I have several measures, and this happens with only one
Hi Anonymous ,
You can try to check the following points:
1. Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky
2. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it,
After a scheduled refresh the report has no data - Page 2 - Microsoft Power BI Community
3. Possibly related to the date:
Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community
4. Is the gateway the latest version, if not, please upgrade to the latest version.
Update an on-premises data gateway | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi Anonymous ,
You can try to check the following points:
1. Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky
2. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it,
After a scheduled refresh the report has no data - Page 2 - Microsoft Power BI Community
3. Possibly related to the date:
Solved: Power BI Service - Data Missing after refresh - Microsoft Power BI Community
4. Is the gateway the latest version, if not, please upgrade to the latest version.
Update an on-premises data gateway | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly