Have you tried also running the black ground wire from the transducer to one of the analog grounds on your MyDAQ? The DAQ measures a potential, without a ground reference the device will not be able to measure anything.
You could also use an analog output on the MyDAQ to produce the excitation voltage rather than using an external power supply.
Hope this helps.
-Nick-
Nick C | LabVIEW Platform PSE | National Instruments