Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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".
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.
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
138 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |