Error: Value cannot be null - Empty Columns

A few customers are seeing an issue with Synapse pipelines for Microsoft Graph Data Connect for SharePoint.

The symptom is straightforward: you get an error message saying that the "Columns" parameter in the request is null. It shows something like this:

Operation on target TTT failed: 

Activity failed because an inner activity failed; 
Inner activity name: XXX, 
Error:  
    ErrorCode=UserErrorOffice365DataLoaderError,
    'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,
    Message=Office365 data loading failed to execute. 
    office365LoadErrorType: PermanentError.
    Value cannot be null.
    Parameter name: Columns,
    Source=Microsoft.DataTransfer.ClientLibrary,'

This error is basically telling you that the Columns parameter is required and cannot be null. 

The columns, defined in the source definition of the copy data task, should have been automatically populated for you, so this is not expected.

To fix it, you can try these steps:

• Opening the pipeline that failed

• Select the copy data task in the pipeline

• Select the source tab

• Under "output columns" click on "Clear"

• Under "output columns" click on "Import Schema"

• Publish the pipeline changes

• Trigger the pipeline again

The picture below shows the two options you need to click on

Click on "Clear", then click on "Import Schema"

I hope this article can help you fix your pipeline. For more articles on Microsoft Graph Data Connect for SharePoint, see https://aka.ms/SharePointData