Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

JS-PBI

Renaming columns in Power Query doesn't show up in Power Bi desktop model/data/report view

Submitted by on ‎06-22-2023 12:44 AM

When renaming columns in the power query editor (Table.RenameColumns) the steps are applied correctly.

When clicking close and apply the table is refreshed and the old column names are there. Renaming doesn't get through.

 

Power Bi reports refreshed on the Power Bi service don't have this problem. This problem first appeared Friday the 16th.

We use the Dataverse connector to connect to dynamics.

Status: Accepted

Hi @JS-PBI ,

The issue has been reported internally, if there're any progress, I will update here.

 

Best regards,

Community Support Team_yanjiang

See more ideas labeled with:
24 Comments (24 New)
Comments
AVESTO
New Member
‎11-30-2023 07:44 PM

Hi @v-yanjiang-msft 

 

As per @NBurnat comment above, I too am experiencing the exact same issue.

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)

AVESTO_0-1701401663269.png

 

However query editor is closed and data is loaded... the Rename Columns doesn't hold

AVESTO_1-1701402094280.png

 

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. 

SlackDave
New Member
‎01-22-2024 05:13 AM

This quite big bug has been reintroduced with either the Nov or Dec update. The August update download seems to be the only working version on this currently

 

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

Anne-MarijnV
Frequent Visitor
‎07-31-2024 06:40 AM

having the same issue with a dataverse table right now

EAD
New Member
‎11-11-2024 04:42 AM

Just noticed thie issue today and it is affecting old and new Datasets and Reports.

Everything was working fin until last month, not sure what changed
Now the renaming step from the Query Editor is ignored

All my reports are displaying errors becuase they column names on the Data model are different
Data sets change
Power Automate stopped working because the columns no longer exist😠

This is a great deal of time and effort to manully adjust column names!

 

Idea Statuses