Keep source column names when ingesting into a lakehouse

Hi Fabric Team,

could you please make it so that all source column names are not lost when using a Dataflow Gen 2 to ingest from a SQL Server view into a new lakehouse? Further, I was expecting Power Query in dataflow to behave the same way as in Power BI Desktop, that is, renaming all columns within dataflow does not affect the respective columns in the lakehouse table (a known issue, I understand), so I don't really see the point of being able to rename the columns in dataflow in the first place if later on you are going to use the lakehouse table as your datasource for a report semantic model (scenario is we need to persist on-prem data into OneLake, and no, we do not want to use a DataWarehouse).