cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
S_D Frequent Visitor
Frequent Visitor

Refresh issue: Expression.Error

Hi everyone,

 

When I refresh a table in Power BI, I got this message:

"Expression.error: the columns "column15" of the table was not found"

 

Indeed, initially I had 15 columns in my datasheet where column 15 was empty, but with the second update of my datasheet, the empty column was deleted (because not needed).

But when I want to refresh the table in Power BI, I get the error that there is a column 15 missing. 

How can I solve this in Power BI?

 

Thanks for your answer!expression_error.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Refresh issue: Expression.Error

Hi @S_D,

 

You need to delete all the reference to "Column15" in Power Query code. 

 

In Query Editor mode, delete the highlighted part in M code under "Changed Type" step.

1.PNG2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Arentir Regular Visitor
Regular Visitor

Re: Refresh issue: Expression.Error

Hi @S_D

You have to update your load in "Edit Query", you probably have a transformation on the column that was deleted. (classic one: Promoted header)

Feel free to share the file if you need further help 

 

Community Support Team
Community Support Team

Re: Refresh issue: Expression.Error

Hi @S_D,

 

You need to delete all the reference to "Column15" in Power Query code. 

 

In Query Editor mode, delete the highlighted part in M code under "Changed Type" step.

1.PNG2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.