Expression.Error for Date

[Anonymous]

Hi,

When refreshing my dashboard an error message appears "Expression.Error: The column '01/10/2017' of the table wasn't found".

The dashboard is connected to an excel spreadsheet that has been trasnformed within Power Query in PBI. I set this dashboard up in October (with previous data dating back to 2016), November's data successfullly pulled through but now when refreshing, it is displaying an error for october.

October's format within the spreasheet matches all other date formats. When I go into Power Query in PBI and click 'go to error' it just goes back to an applied step but doesn't show the error at all or any data for that matter.

Any help on this would be greatly appreciated!

[Anonymous · Accepted solution]

@Anonymous,

In Query Editor of Power BI Desktop, look into “APPLIED STEPS”, some steps should make changes/calculation on the ‘01/10/2017’ column(e.g. Change Type), you should delete such steps to eliminate this error.

.
Regards,
Lydia