Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |