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

PBI Desktop Refresh All - Expression.Error

Hi all,

 

Refreshing my tables via Refresh in Report view directly from PBI Desktop returns the following error:

 

Expression.Error: The column '' of the table wasn't found

 

I'm able to refresh the data of the error table and other tables individually via Data view - not ideal.

There is no clear indicator on what colum could be causing the error. The table does not reference other tables. Source URL tested, no problem there.

 

Any ideas?

 

screenshot:

Refresh fail.PNG

 

6 REPLIES 6
Highlighted
yesenita Frequent Visitor
Frequent Visitor

PBI Desktop Refresh All - Expression.Error

Hi all,

 

Refreshing my tables via Refresh in Report view directly from PBI Desktop returns the following error:

 

Expression.Error: The column '' of the table wasn't found

 

I'm able to refresh the data of the error table and other tables individually via Data view - not ideal.

There is no clear indicator on what colum could be causing the error. The table does not reference other tables. Source URL tested, no problem there.

 

Any ideas?

 

screenshot:

Refresh fail.PNG

 

Baskar Super Contributor
Super Contributor

Re: PBI Desktop Refresh All - Expression.Error

Hi yesenita ,

 

I need some some clarification , let me know

 

1. Are you trying to change the data source. [eg. developed in Excel but now changed in SQL like this]

 

2. Did you changed your column data type in Data Modelling Screen [Eg. Text to Date like this ]

 

let me know

Moderator v-qiuyu-msft
Moderator

Re: PBI Desktop Refresh All - Expression.Error

Hi @yesenita,

 

From the error message, it seems that there is a calculated column in the table StandingsMLB and the expression is incorrect. Please check if any column in this table contains error.

 

Besides, please enable tracing on Power BI Desktop then check the detail error message around the time that you are refreshing. For more information, please refer to this article: Power BI Desktop Trace Logs Analyser.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yesenita Frequent Visitor
Frequent Visitor

Re: PBI Desktop Refresh All - Expression.Error

All is working fine now. I wasn't able to recreate the error to retrieve technical details.

 

Thanks for your help and suggestions!

yesenita Frequent Visitor
Frequent Visitor

Re: PBI Desktop Refresh All - Expression.Error

@@Qiuyun_Y I was able to refresh native PBDesktop file just fine, but refresh in Power BI online failed

PBI online OBP Refresh fail.PNG

 

Moderator v-qiuyu-msft
Moderator

Re: PBI Desktop Refresh All - Expression.Error

Hi @yesenita,

 

Which data source did you connect to? Please share more information about refresh. As this thread is too old, please create a new thread and describe the issue clearly.

 

Best Regards,
Qiuyun Yu

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors