I have a power query that when using the Power Query editor, shows error if bad data is entered in a spread sheet. however when this query is added to a sheet, it just shows blank. Id prefer it show Error to give user feedback that something is wrong and likely they need to check their inputs. Googling hasnt revealed how to do this.

I know i can replace these errors, but it only allows a numeric value to be repla
ced, which isnt going to help.

In the below case, the query combines data from multiple sheets, but one of the cell contained a ‘.’ resulting in the Error cell. Would like this to propagate to the sheet instead of being rendered as blank

[![enter image description here][1]][1]

THanks much if anyone knows how to do this.
[1]: https://i.sstatic.net/657etMdB.png