Forum Discussion
Discrepancy between Power BI Web and Desktop Versions
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.
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.