Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

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

View solution in original post

1 REPLY 1
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.