Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I am publishing the report from Power BI Desktop, the date having the following year
After publishing the report, Date Year is starting from 1899
When i published the report it show the proper date in the service after refreshing the service browser its get changed and it shows the Date Year from 1899.
Please suggest reason why Date Year is starting from 1899.
Solved! Go to Solution.
There are few possible reasons and solutions for this behavior:
Date Data Type:
Date Format in Power Query:
Date Values Prior to 1900:
Date Transformation in Power Query:
Date Display Format in Report Visuals:
Date Format in Power BI Service:
Date Hierarchy:
Data Refresh Behavior:
Test with a Simple Date Column:
Contact Power BI Support:
There are few possible reasons and solutions for this behavior:
Date Data Type:
Date Format in Power Query:
Date Values Prior to 1900:
Date Transformation in Power Query:
Date Display Format in Report Visuals:
Date Format in Power BI Service:
Date Hierarchy:
Data Refresh Behavior:
Test with a Simple Date Column:
Contact Power BI Support:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.