Make DataFlow destination handle column names with spaces better when matching to an existing table

If you have a Power Query DataFlow with a Destination set to a NEW table in a Lakehouse, any column in the Power Query with a space in the name will automatically get renamed to a column name where the space is converted to an underscore. So [My Column] in Power Query becomes [My_Column] in the lakehouse table.

No problem.

But if you then set up a second Power Query and select an EXISTING table as the destination, it somehow cannot figure out that [My Column] in Power Query should get mapped to [My_Column] in the lakehouse table.

EITHER:

1) STOP replacing spaces in column names with underscores

or

2) figure out how to make the mapping work in the second scenario.