Discrepancy between PowerBI Desktop Figure & same figure when published

[stokidez]

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!

[v-xulin-mstf]

Hi @stokidez,

Glad you found the cause of the issue, you can try this method to show time at local timezones in the Power BI report.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[stokidez]

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,

[v-xulin-mstf]

Hi @stokidez

Please refer this method:

https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-...

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[stokidez]

Thanks  @v-xulin-mstf 

I've read the blog and watched the video. I do not need to change time zone on a per user basis. I just need to change time zone when its published for all users by the same degree. It mentions a change to the DAX code to implement but doesn't specify. How would I achieve this please?

[v-xulin-mstf]

Hi @stokidez,

Is your issue that the custom data is not implemented properly in the service?

Best Regards,

Link

[amitchandak]

@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/

[stokidez]

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,