Forum Discussion
Power Query expression error - how to locate excel file causing error
Hi, I have a function that extracts data from excel files stored in a OneDrive folder. It was working great, but have been getting an expression error and am unable to find the source excel file ...
Right click on the query and select edit.
It is likely that the column that is throwing the error has been deleted. The step throwing the error will refer to this column, it could be deleting it or changing the type.
Click through the applied steps on the right from the first and it should say be able to notice the error first happens.