Question

A nightly Fabric data pipeline that copies data from an on-premises SQL Server to a lakehouse has started failing intermittently. You need to determine which specific activity is failing and view the detailed error message and input/output for that activity run without adding custom logging. Which action should you take first?

Accepted Answer

Open the pipeline's run history in the Monitor hub and drill into the failed run to inspect the individual activity output and error details

Answer

Enable diagnostic settings to stream pipeline logs to an Azure Log Analytics workspace and rebuild dashboards

Answer

Add a Fail activity and a Set Variable activity to capture error messages into a lakehouse table

Answer

Increase the retry count and retry interval on the Copy activity to prevent the failure