Forum Discussion
DataSource.Error: Microsoft SQL: Adding a value to a 'datetime2' column caused an overflow.
Hi AntonH -Go to the query editor in Power BI (Power Query).
Look at the column that holds the date values and see if there are any invalid dates eg: 0000-00-00, or dates far in the future or past that could cause this issue.
Replace or Filter Out Invalid Dates:In Power Query, you can use the Replace Values function to replace invalid date values with null or a valid placeholder date.
Alternatively, you can filter out rows where the date is invalid using the Filter Rows option.
Replace values that may cause overflow errors (like 0000-00-00) with a more manageable default date, example: 2000-01-01check the column header of date and data type choose date/datetime data type
Hope this prevent the overflow errors.
i was having the same issue while trying out adventureworksDW2022 dataset and i had no much knowledge of sql editing or it wasnt possible to filter out the column as the dataset rows are huge.
i tried power query editor --> Transform--> Format--> trim/clean --> now change the date type to date .
hope this helps somone new at power bi