Anonymous's avatar
Anonymous
Not applicable
1 year ago
Status:
Investigating

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

Description: When using Power BI with a Dataverse source, renaming columns within Power Query does not reflect the changes after hitting “Close and Apply.” The columns revert to their original names ...
Data Modeling
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Dataverse Column Names Display Names vs. Renaming in Power BI
PowerBI changes my dataverse column names
Tables in PowerQuery editor do not reflect PowerBI data model using Dataverse connector

 

Here are the posts I could find with the same issue. It turns out this was actually a "Feature" Microsoft added but they didn't consider that this would cause problems and have ignored any requests for help.

 

Forcing any changes to names to be completed in the model view and not allowing it to be reflected in Power Query means that the two names will never be in sync, and it will always be difficult to match the model-view column to its Power Query counterpart.

 

We should be able to turn this feature off!

 

Power BI July 2022 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

Completed Ideas