Change header table in Power BI Desktop

[Anonymous]

hi,

I created a report in Power BI Desktop and then published this report in Service.

The data source is a sharepoint list.

I want to change the titles of the header from "process" to "processnames" in one table header.

When I rename the column in the query editor, the report on BI Service does not apply this change.

I changed the table header in the sharepoint list from "process" to "processnames" as well.

When I refresh the data in Desktop, I receive the following error message:

When I now try to refresh the dataset in BI Service, it doesn't work any longer.

How can I rename column headers in Desktop?

Kind regards

Ann

[Anonymous]

@amitchandak 

If I rename the column in Power BI Desktop I still get the following error message below.

This is strange, because I renamed the columns both in Desktop and in the data source in Sharepoint back from "processname" to "process".

[Anonymous]

Hi @Anonymous 

I have a test on this issue and I find though you rename the column name in Sharepoint, in Power BI will still show the original column.

I add a Process column in Sharepoint Document.

Get data by connecting to sharepoint online list. I find Process column.

Then I change the column name Process to Processnames in Sharepoint, then I refresh desktop, I still get Process column instead of Processname column.

Now I try your another, I rename Process to Processnames in Desktop by myself. Then I republish this report to Service. Due to the data source is sharepoint we just need to configure credentials correctly then we can refresh the dataset in Service. I refresh report in desktop and service. It works well. You can see as below, they change from A to C.

In desktop:

In Service:

Please check whether you build some relationships between process column in desktop and whether you configure the credential correctly in service.

Best Regards,

Rico Zhou

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

[amitchandak]

@Anonymous , if you  rename and change in power bi, it should propagate, You can republish and clear cache and check on power bi service

rename of the column at SharePoint means the old column name is not available. I think that is causing the issue

refer if this can help

How to Deal with Column Rename at Source: https://youtu.be/meUxcbwujl8