Column name changes and data missing

[Slappyafish]

Hi All,

Currently running into a problem where my dataset is returning incorrect names and removing columns on close and apply. for example: in power query I have a column called "Name", this is renamed to "Project Name" in some of the applied steps, once this is applied and I go to report view, the column name goes back to "Name". There are a few other instances like this, as well as removing columns from the dataset.

I have tried the following:

• Unhiding the values from the table in the report view and this doesn't work
• Duplicating the table in transform data to see if it pulls through
• Starting with a fresh powerBi report
• The dataset itself is a direct query dataset and I have tried switching to import and still have the same issue

What's strange though is that the Test environment reports work as intended but not the live environment reports, I have tried using the Test ones as a basis and switch the URL over to live but still not working.

Any help would be much appreciated,

Kind Regards,

Jake W

[danextian]

Can you please post your queries with the data source masked?

[Slappyafish]

Hi @danextian

Here are the applied steps for the table in Power Query

Here are the applied steps of the table

Here are two columns which aren't working correctly:

Quality and project name within power query

This is an example of the project name changing Name in the report view, data section

Project Name has changed to Name instead in the Report View, Data section

Here is an example of the Quality column not even appearing in the report view, data section

Quality column doesn't appear within the Report View , Data section

Kind Regards,

Jake W

[v-cgao-msft]

Hi @Slappyafish ,

Please go to Table view and check whether the Quality column is hidden or not. the hidden columns will not appear in the Report view.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Kedar_Pande]

@Slappyafish 

1. Check if the column renaming is supported by your source. Some data sources may not allow renaming of columns at the Power BI level
2. If you have added or renamed columns in Power Query, after applying the changes, refresh the dataset in the report view to ensure that the new structure is picked up.
3. Clear the data cache in Power BI Desktop

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Slappyafish]

Hi Kedar,

Thanks for the response,

Have removed all steps in Power Query after the navigation as a test and for some reason it still renames the columns, even when there is no step telling it to do so.

Also have cleared the data cache and still no luck,

Any other ideas?

Kind Regards,

Jake W