Solution
Check the sensor datasheet and confirm whether the sensor is a MEMS-based sensor or an IEPE sensor. If the NI‑9230 shows unexpectedly low readings when using a third‑party accelerometer, it is likely because the sensor is non‑IEPE and requires external excitation power.
MEMS-based sensor operates differently from IEPE sensors. IEPE sensors can be powered directly by the NI-9230 using the built‑in 4mA excitation current when IEPE mode is enabled in the task configuration. However, MEMS-based sensors do not use IEPE excitation and instead require their own external DC excitation voltage.
To resolve this issue, first disable IEPE excitation in the DAQmx task. Then verify the sensor configuration and provide the required external excitation voltage to the MEMS-based sensor according to its datasheet. Refer to the sensor's wiring diagram for correct connections. Example is as below, where the sensor includes a dedicated excitation wire (red wire) for the external voltage supply.

After supplying the proper excitation voltage, the MEMS sensor should operate normally and produce expected amplitude readings.