Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Wienforth
Frequent Visitor

Power BI Desktop showing different names & columns than Power Query Editor of the same table

Hi everyone,

 

I am currently loosing my mind on a problem i encountered yesterday and i still have not found the error. 

Power BI Desktop and the Power Query Editor show different columns and different column names. Some of the columns shown in Power Query Editor do not load into Power BI.

 

One example is the column "tpgde_planprofitcontributionwithrisk". This column shows up in the Power Query Editor (as seen below with the preview refreshed a couple of seconds before) but does not show up in Power BI after loading.

Some of the columns that do show up in Power BI Desktop have a different name than whats shown in the Power Query Editor.

Wienforth_0-1673350021352.png

Wienforth_1-1673350197059.png

 

I tried the following, unfortunately nothing worked:

- made sure that "Include in Report refresh" is active

- tried renaming the column in Power Query Editor (still didn't show up after load)

- The usual tech level 1 support tip of updating / restarting Power BI and my PC 😄

- Changing the query and hitting Close & Apply

- Refreshing the table from Power BI Desktop by right clicking the table --> refresh

- Clearing the Power BI cache and reloading the data

 

Best regards and a happy new year to everyone!

 

 

1 ACCEPTED SOLUTION

Hi, I had a similar situation when I used the Dynamics 365 Dataverse connector. I've renamed the columns in Power Query Editor, but in Power BI Desktop they wouldn't change and I've tried everything. But then I read an article saying that Microsoft had some updates: "In the July 2022 Power BI update, they updated the Dataverse connector. The connector now uses the display names from a Dataverse table. Dataverse columns have internal name and display names and previously the display names were not available."

Maybe it's a similar situation for you.

View solution in original post

19 REPLIES 19
Santteri
New Member

But don't worry, the names can be changed on the Power BI Desktop side, in data view, so not on the Transform side.

In this case, the new names will remain until the report.

Yep... but it creates a mess, adds unnecessary steps and defeats the purpose of having a rename step in the data model.  Some of the tables in my model have over 300 columns (not my design!), hence my frustration 🙂

MoraesLucas
Regular Visitor

Same over here, made my points in an older post: Solved: Re: Power BI Desktop automatically changes column ... - Microsoft Fabric Community 

Should have an option to deactivate auto naming... 

bhalicki
Helper II
Helper II

Hi,
Sorry to dig up an old post, but I have just hit the same issue and loosing my mind trying to figure out what's going on.

I have tried clearing the cache, reloading all data, but still the table in PowerQuery Editor doesn't match what I see in PowerBi.

I'm using PowerBI Desktop version 2.118.621.0 64-bit (June 2023).

I have been taking regular backups of the PBIX (have been making several changes over the last few days) and if I roll back to a previous verison, the issue disappears.

Did you find a solution?

Cheers,

Ben.

Hi, I had a similar situation when I used the Dynamics 365 Dataverse connector. I've renamed the columns in Power Query Editor, but in Power BI Desktop they wouldn't change and I've tried everything. But then I read an article saying that Microsoft had some updates: "In the July 2022 Power BI update, they updated the Dataverse connector. The connector now uses the display names from a Dataverse table. Dataverse columns have internal name and display names and previously the display names were not available."

Maybe it's a similar situation for you.

Hi @Elina_Mirin ,
That would make sense as it appears I am seeing the internal Dataverse tables (and I am connecting to the Dataverse using the Dynamics 365 connector).  What I don't understand is why when I have renamed the tables in PowerQuery editor, the transformations aren't carrying across to PowerBi though... Did you find a solution for your issue?

Because now in Power Bi Desktop you will see the Display name of the columns, not the API name of the columns (you will see the display name as they are in Dynamics 365 dashboards). So no matter how you are renaming in Power Query Editor, they will not be updated in Power BI Desktop (because of the last updates). Anyhow, this will not impact in any way your data - only the name convention will be different.

Hi @Elina_Mirin , I think you might be right.

Strange thing is, I ended up raising this with Microsoft support.  We went to replicate the issue and noticed it was resolved in September 2022 edition.  April 2023 is fine, but appears to be broken in May 2023 and June 2023 editions.  Based on the documentation, it should work as you suggest, but looks like it's been updated and rebroken at some point.  Hopefully it gets resolved soon 😕

Thanks again for your help.

Kind regards,

Ben.

Do we know if this is still an issue with the July 2023 edition?  I'm thinking so based on what I'm seeing.  

 

Any idea when Microsoft will fix this.  

msantin
Frequent Visitor

Hello everyone,

 

I'm using the latest version of powerbi Desktop and the same thing happens to me.

Version: 2.118.828.0 64-bit (junio de 2023)

 

Does anyone know why the names of the fields in the table are not changed?

 

Is there a solution for this? The data source  is sap hana.

 

Thanks in advance

Hi - I have exactly same issue, SAP Hana DB is the source and I'm using June 2023 desktop app.

 

I accidentally lost renaming on around 200 fields across multiple tables, which caused a decent amount of damage to reports using the published dataset. Rolling-back to an earlier version fixed the issue but we now can't perform any query changes without risking the same again.

 

I'll raise an incident with MS, just to highlight. the problem.

 

Nick

Hi all,

I have raised this as a bug here:
https://community.fabric.microsoft.com/t5/Issues/Tables-in-PowerQuery-editor-do-not-reflect-PowerBI-...

If anyone would like to add comments, or vote to get this resolved (it's definitely not a feature!), would greatly appreciate it 🙂

Kind regards,


Ben.

Elina_Mirin
Helper I
Helper I

@Wienforth  @v-jingzhang did you find a solution for this?

I encounter the same problem. I have renamed some columns in Power Query Editor, but in Desktop they don't update and I don't understand why. I've tried everything, including what you've suggested and also I've tried to replicate again the table, but it didn't work. It's the first time whent this is happenning.

Hi @Elina_Mirin thanks for the reminder, I forgot to post my solution here even though it's not really satisfactory. IT told me there was something wrong with my priviliges to access the datasource (dataverse in this case) after they did some changes and gave me all permissions again the error resolved itself.

 

You should check with your IT guy if some of your access rights etc. ran out, that might cause the error for you as well.

 

Best regards

Timo

v-jingzhang
Community Support
Community Support

Hi @Wienforth 

 

My guess is that these "missing" columns may be hidden from the report view. You can switch to Data view or Model view to check if some columns have an eye icon next to the column name in Fields pane. 

vjingzhang_0-1673407025372.png

 

Or in Report view, right click on any column and check the option "View hidden". This can make those hidden fields visible. 

vjingzhang_1-1673407085661.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hi v-jingzhang

 

thank you for your response, you got me there I forgot to mention this in what I tried but this might help a lot of people!

I cannot find the field in the Data / Model View, its not hidden. They are not present in Power BI Desktop at all, only in the Power Query Editor.

 

Best regards

Hi @Wienforth 

 

It's weird. I noticed that when you search the field in Power BI Desktop, you used "profit contri" which has a space character in it. However, the original column name in Power Query Editor doesn't have a space. Maybe you can use the original column name to search or remove the space? 

 

BR,

Jing

Hi @v-jingzhang  

my bad again, the screenshot was to show that the field shows up under a different name after load. Searching for the actual field name returns results but for a different table (where everything works as expected)

Wienforth_0-1673432446295.png

 

Best regards

Timo

 

Hi @Wienforth 

 

Thank you for the explanation. Does only this table have this problem? Does only this pbix file have this problem? I did some test on my computer but the column names are always consistent in both places no matter where I rename them. This problem is strange. What is the version of Power BI Desktop are you using? Is it possible to share a sample pbix which can reproduce this problem without sensitive data?

 

BR

Jing

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.