This issue is related to Renaming columns in Power Query doesn't show up in... - Page 3 - Microsoft Fabric Community. But as yet there has been no answer and I fear that issue may have been buried.
Basically, despite there being steps to rename columns in the Power Query editor... these dont flow through to the resulting Data Model after loading and instead columns are still named as their original source.
PBI Desktop Version: 2.123.742.0 64-bit (November 2023)
See below very basic querry which:
- connects to Dataverse 'Source' CommonDataService.Database("orga12a3b4c.crm6.dynamics.com")
- 'Navigates' to data Source{[Schema="dbo",Item="vf_mytableofdata"]}[Data]
- 'Removes Columns' - standard Table.RemoveColumns script
- 'Renames Columns' - standard Table.RenameColumns script (see below)
Columns display in Preview as correctly named however, once query editor is closed and data is loaded... the Rename Columns doesn't hold
If i put the Table.RenameColumns step AHEAD of the Table.RemoveColumns Step... no difference. The Table.RemoveColumns step still executes and the un-wanted columns removed, but the Table.RenameColumns step does not hold and the columns remane as their originally loaded name.
Surely this is more widespread than just me. I note there is yet an answer in the original thread.