Do you use any of these?
If so, you have a third party integration that is messing with the Recorder database filtering in an way that it should not. See: 2024.7: Time to resize your cards! - #84 by Snuffy2
As this has generated an architecture discussion about providing a way to filter the recorder safely it may not be a quick fix. Your current options are:
-
Downgrade to the last HA core version (2024.6.4) and wait for a fix, or
-
Stay on 2024.7 but stop using the offending 3rd party integration(s).