Data Format.Error Invalid Cell Value #REF

Hi, smjzahid ;

#REF is generated in the Excel sheet, not in PQ or the data Model, so somewhere in a sheet that error is occurring.

Check the source of the query that is having the error and check that source (is it an Excel table?) for the error.

You may not be seeing the error in the PQ editor as it may not have loaded all rows from the source - you only get a preview in the editor.

Try this:

1. Duplicate your query

2. Delete all steps except the Source & Navigation steps

3. Close & Apply - this should result in a pop-up like this telling you there are errors in your query.

4. Click on the View errors link in the yellow-highlighted section.

5. This creates a new query in the PQ Editor that lists the errors in your query, including the row number where the error is

6. Check the rows for your error(s).

If that doesn't help you find the issue please supply your source data file.

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