Forum Discussion
Error in the Date format
Hi Stephane,
Thanks for the input.
We have a query, we are not getting the date ranges from 01/01/0001 to 12/31/0099 in the report view.
Kindly guides us haow to resolve this issue.
Thanks,
Priyanka
Hi Anonymous
It seems the date ranges from 01/01/0001 to 12/31/0099 are not supported in Power BI. Below is my test result.
From the official documentation, only years between 1900 and 9999 are designed to be supported.
Data types in Power BI Desktop - Power BI | Microsoft Learn
DATE function (DAX) - DAX | Microsoft Learn
Although the years between 0100 and 1899 appears supported at present according to the test, this cannot be always guaranteed as they are not in the designed allowed range.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!