Forum Discussion
Web Service and Desktop Client show different Result for same Measure
Ok, will do so. Meanwhile I noticed another report with the same issue. In this case there are no formulas involved. All I do is to get the field 'ID Employee' from Dynamics CRM DB (on premise) into a 'card' visual and do a COUNT in the visual settings.
In the client it counts 177 ID's and on the web only 171.
This is seriously bad as it undermines the credibility of all reports. I cannot possibly check all of them and compare the results between client and web service.
My assumption is that the problem is related to using the CRM DB as data source (if you recall, I also use it in the initially reported problem).
Hi skasper ! Did you find a solution ?
I have a similar problem : I developed a report with Power B.I Desktop and I published it on Power B.I Service. Problem: The data displayed in the Power B.I service is different from the ones displayed in Power B.I desktop. In Power B.I Desktop, values are aggregated by month / year. By consistency check, I'm sure that these values correspond to reality. So there is a problem in Power B.I service.
Hi Anthony1981,
Unfortunately, I cannot say that I did. I eventually refrained from using these measures. The behavior of PBI service is neither consistent nor deterministic. I am very wary now and always double check any published reports. Cumbersome, to say the least.
Good news is that I have not encountered further similar issues.
Sorry I cannot help any further than that.
Hello skasper,
Thanks for your answer. I opened a support ticket to report the problem. I suspect a problem related to dates formats that differs in the web service compared to the desktop. While waiting for a response from the support I will apply your method and check each of my publications.
Cheers
A.