Copy Job from SQL Server DB Error - advice needed

[HankoSwart]

Hi All,

I have been trying to get our on-prem SQL DB data into Fabric but with no success when using the Copy Activity in a pipeline or by using a standalone Copy Job. I can select tables and columns from the SQL DB when setting up the job and also preview the data, so clearly the connection works.

No matter what I do, I keep getting the same error when running the job:

"Payload conversation is failed due to 'Value cannot be null.

Parameter name: source'."

I've now tried the following and am getting the same error every single time:

1. Updated the Gateway to the latest version

2. Recreated the connections in Fabric

3. Tried different databases

4. Tried different tables

There is also an Error Code with a link to Troubleshoot connectors - Microsoft Fabric | Microsoft Learn but this is unhelpful as the error code is not listed. I also cannot see where this "source" parameter is

Any help would be greatly appreciated

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

Hi @HankoSwart,

Just following up on my earlier suggestion to raise a support ticket regarding the issue. Could you please confirm if you’ve been able to proceed with it, or if you need any assistance with the process?

Thank you for your understanding and participation.

[v-prasare · Accepted solution]

Hi  @HankoSwart , 

since you blocked on this, In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support