Forum Discussion
Discrepancy between PowerBI Desktop Figure & same figure when published
I have a discrepancy with a figure (Breaches in 20/21) being displayed when I publish my report.
Here is how the figure is filtered:
Figure in PowerBI Desktop after refresh:
Figure when Published & viewed through browser:
And here is the dataset - I have a strong feeling its related to the four records which have a date identified as 1st April. There are 26 records which meet the criteria of 01/04/2020 -> 31/03/2021
As a temp fix I've amended the dates from 31/03/2020 -> 31/03/2021 - this displays the correct 26 figure.
Data is below....
Any help much appreciated - I'm stumped!
7 Replies
stokidez , 1. Create browser cache, republish and check
2. Is there any time zone setting done at power bi service - refer: https://4pbi.com/resolving-timezone-issue-on-power-bi-service/
Thanks amitchandak - it's not a caching issue as I've deleted cache/temp files, restarted etc.
The date field in question is a custom field where I'm forcing it to be local time. How would I amend this calculation to stop it being changed through the PowerBI service?
Thanks,
Hi v-xulin-mstf afraid I've still not found a solution to the issue. See below, note how the dates highlighted change when published to the BI service:
In PowerBI Desktop:
In PowerBI Service:
I can see having scoured the forums that several people have had a similar issue but cannot see a solution that can be applied. If anyone can shed any further light I'd be really interested.
Thanks again,
Hi stokidez
Please refer this method:
Best Regards,
LinkIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
