Dataflow errror checking

[_Kevin_]

In the desktop app finding and fixing refresh errors is easy after generating Query Errors. I have moved some large queries to Data Flows. My queries get data from excel files that require user inputs. These are often subject to errors.

An error report in the dataflow is limited to, as example:

 Error: DataFormat.Error: Invalid cell value '#N/A'. Request ID: ##### Activity ID: ######

Question: How do I get more details like the specific source files, sheets and rows with errors? We do not have premium space so cannot use reference queries like as explained here.

Thank you

[dax]

Hi @_Kevin_ ， 

You could check each step to see which step will cause error and check which sheet contains '#N/A'. If you want to get detailed reference, I suggest you could check this in local desktop app, then you could modify it and  paste it in service data flow.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.