Forum Discussion
Different Filed Name Between Power BI and Power Query
- 1 year ago
After submitting support ticket to MS Official, the support guide me to the answer.
In conclusion, it seems the issue I'm experiencing is a feature rather than a bug. And there is no an option to enable or disable it based on user preference. Manually renaming the fields again inside the Power BI model is the only way.
Hi PaiYa ,
I have never experienced a question like this, and without further information is difficult to pinpoint what is happening. What I can suggest is that you try and rename the columns in the Desktop and not in Power Query, this will add a new step to the Power Query also, but it should persist the name in the model.
Can you please try and let me know the result.
Hi MFelix , thanks for you reply.
I'm not sure whether your reference to "Desktop" means Power BI Desktop. My workflow is: import data from Dynamics 365 → Transform Data → edit data in Power Query → load into Power BI. I'm not renaming fields in a local Excel file or anything like that — I'm renaming them in Power BI Desktop during the Transform Data step, but the changes are not taking effect.
- MFelix1 year agoSuper User
Hi PaiYa ,
When I refer Desktop is the Power BI Desktop. What I mean is after you have done the load from the Power Query just double click the column name or Right click and select rename the column. Has I refer this will generate a step on Power Query automatically.
Then refresh the model and check if the name persists or not.