Expression Error

[joseph248]

HI All,

I am getting this expression error, I want to make changes to the header of the underlying excel data and changed the header, but now Power BI refresh is giving me this error, when I click on refresh.

HOw do I make Power BI accept the new header title.

[v-robertq-msft · Accepted solution]

Hi, @joseph248 

According to your description, you follow my steps:

1. I make the same change as what you did, and I get the same problem, like this:

2. Then I select the step before current step in the “Applied steps” on the right, like this:

3. I change the column to be consistent with the column name in Excel, like this:

4. I go to the “Advanced Editor” to change the column name in last step:

And you can get what you want.

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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