Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Expression.Error for Date

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!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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