Forum Discussion
AdministratorDifferences in dates between PowerBi Desktop and online publishing
Hello, I have a problem when I publish what I did in my PowerBi.
In the powerBi desktop I see it perfect, starting the dates on the first date of the table, but when I publish it and see it via web it appears to me since 1899 (attached photos).
Does anyone know why it may be?
5 Replies
- parry2k
Super User
Syndicate_Admin do you have full data in desktop what you have in Power BI service after refresh.
Syndicate_AdminIn the PowerBi desktop I see the filter well, filtering by the years that there are actually on the date of the orders in the database.
When I publish it in the PowerBi service is when it transforms the data and starts in 1899.
Sorry I can't reproduce your issue.
Would you mind providing more information, such as how you created the date on Power BI Desktop. Was it a column of dates created using Dax or did you create a date table with a hierarchy?More details will help you to solve the problem better.
Best Regards,
Caitlyn Yan
- Syndicate_Admin
No, I have the date field directly from the prestashop database. I add catches.
In the PowerBi desktop it looks great and filters well, it is when exporting it (publishing it) when I create years that do not exist.
- Syndicate_Admin
Nobody knows why it can happen?¿¿
