Energy Dashboard
Hourly Consumption in Energy Dashboard
If you don’t need consumption tracking or use another integration for this, you can disable consumption sync during initial setup or in the integration options. This will prevent consumption sensors from being created and disable the history sync service.
Hourly consumption from Hydro-Quebec is not live. The hourly consumption will sync automatically when it is available from Hydro-Quebec. On the website you can only see the hourly consumption from the previous day. With hydroqc2mqtt you will sometime be able to see consumption of the current day. There is always a delay of a few hours before HQ publishes the information.
When you enable sync of the hourly consumption one or more sensors are created in Home-Assistant named “* Hourly Consumption” depending on your rate.
Rate D and D with CPC option (winter credits)
In the Energy Dashboard you will have to use the “Total Hourly Consumption” sensor in the “Grid Consumption” section.
Flex-D and DT (dual energy)
For FlexD and Bi-Energy rates you can put the sensors “High price hourly consumption” and “Reg price hourly consumption”. This will allow you to distinguish the two types of consumption in the dashboard.
The “Houly Consumption” sensor will always have a state of “unknown”. We do not have a state for it, we need to create it in order to push the statistics to it and for it to be available to add to the Energy Dashboard, but there will never be a value for it.
Historical Energy Consumption
Initial Setup
Enabling hourly consumption sync during hydroqc-ha integration setup will automatically sync:
- Data from the last 30 days via regular sync (efficient and fast)
- For more than 30 days: automatic CSV import in the background during initial setup
Manual History Import
The hydroqc-ha integration provides a Home Assistant service to manually import hourly consumption history up to 2 years back.
Service: hydroqc.sync_consumption_history
Parameters:
days_back: Number of days to import (default: 731 days = ~2 years)device_id: The HydroQC device corresponding to your contract
Usage in Actions:
action: hydroqc.sync_consumption_history
data:
days_back: 365 # Import last year
target:
device_id: <your_device_id>
From the UI:
- Go to Developer Tools → Services
- Select the service HydroQC: Sync consumption history
- Select your HydroQC device
- Specify the number of days (optional, default: 731)
- Click Call Service
}
- Import runs in the background and can take 30 minutes to 1 hour depending on data volume
- Don’t run the service multiple times consecutively - wait for the previous import to complete
- Check Home Assistant logs to monitor progress
- Import uses Hydro-Québec’s CSV API (more efficient for large periods)
hydroqc2mqtt (Legacy)
If you’re still using hydroqc2mqtt, the old method with buttons and switches remains available on the device.
Managing Statistics
If you need to correct or delete hourly consumption statistics (for example, after an incorrect import), you can do so via Home Assistant’s Developer Tools:
Access statistics:
- Go to Developer Tools → Statistics
- Search for your hourly consumption sensors (e.g.,
sensor.home_total_hourly_consumption) - Click on the sensor to see all recorded statistics
Adjust or delete a statistic:
- Click the Adjust sum button to correct an incorrect value
- Or select a date range and click Delete to erase data from a specific period
- Changes will take effect immediately in the Energy Dashboard
}
Deleting statistics is permanent and cannot be undone. Make sure you want to delete the data before confirming. If you accidentally delete history, you’ll need to re-import the data using the hydroqc.sync_consumption_history service.
Common use cases:
- Correct outliers caused by import errors
- Remove duplicates after accidental multiple imports
- Clean up statistics before a complete re-import
- Adjust data after a timezone change or DST transition