Dataverse Columns Renamed in Power Query Show Display Name After Close and Apply

Hi Anonymous ,

Thank you for the detailed summary, very much appreciated 🙂

I have retested this issue on Version: 2.137.1102.0 64-bit (October 2024).  Interestingly, this only appears to impact tables created in the new version and not tables created before the 'feature' was implemented.

I tested on a PowerBi report built on 2.116.966.0 64-bit (April 2023) (purposfully remaining on an old version until this issue was resolved).  When I add new columns to an existing table and rename, the new column name persists into the final data model.  However, if I create a new table and rename the columns, then the Dataverse column name persists into the final data model.

This "feature" makes no sense at all.  Some of the column names in our Dataverse are designed to be readable by end users (and therefore may contain descriptive text).  It is extremely difficult to identify the original field in the data model based on this descriptive text.  Renaming a column is a key feature of ETL, so I don't see why we would want the original column name to persist into the final data layer instead of what we have assigned.  I would expect the final data model to appear exactly as it does after all data transformations have been completed in PowerQuery.