Discrepancy between Power BI Web and Desktop Versions

[andreame]

Hi,

Since a few days I noticed something very strange. Some values differ between the Web version and the desktop version. My data has been refreshed at the same time for the web version and the desktop one.

Here you can find some examples:
This is a screenshot from my desktop app. You can see that each row has a value for "Requested Delivery Date"

While this is a screenshot from the same dashboard published and took from PowerBi web. The issue is only on this field, some of the entries are shown as "Blank" and translated as 30.12.1899.

I tried to change format and re-published, the dates were correct again. But with the next refresh it broke again.

Thank you for your help!

[Anonymous · Accepted solution]

Hi, @andreame 

The current issue is that power BI service can't calculate due to inconsistencies in your data source's date format and in Power BI service, resulting in a "default" date and zero date (1899-12-30).

Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31? - Stack Overflow

Meaning, when you hit refresh, your latest data will be passed into the Power BI service, and then the Power BI service can't read it as a normal date, and then it will automatically convert to this 0 date.

You should check the date column format of your data source. You can check the following case:

Solved: Date format - Desktop vs. Service - Microsoft Fabric Community

To avoid this problem, set the date to the international standard date format.

Best Regards

Jianpeng Li

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