Forum Discussion

yesenita's avatar
yesenita
Frequent Visitor
10 years ago

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 refres...
yesenita's avatar
yesenita
Frequent Visitor
10 years ago

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:

 

Baskar's avatar
Baskar
Resident Rockstar
10 years ago

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