Forum Discussion

PeterHarket's avatar
PeterHarket
Frequent Visitor
4 years ago

PowerBI changes my dataverse column names

Hi!   When I connect to my dataverse database, all the right column names are displayed in Power Query (Transform data tab). However, when I close and apply, the fields in my tables on the right ha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi PeterHarket ,

 

It's weird. To my knowledge, this action will apply all changes to Power BI Desktop.

Are there any operations to rename the columns?Please provide some screenshots to help us clarify your scenario.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HitachiOG's avatar
HitachiOG
Frequent Visitor
3 years ago

I experience the same thing.  Never happened in the past with Dataverse.  What appears to happen is that for some fields, a friendly name (no doubt coming from Dataverse) is automatically applied.  You don't see this in PQ but when looking in Desktop the friendly name appears.

That is fine, but the issue I see is that if, in PQ, I rename the field.  In Desktop, the automatic friendly name is used instead - so my PQ is ignored.  I can still override the auto name in Desktop, but it is annoying.

For example, in PQ I rename the field: 

but in Desktop I see the auto generated name of Account