Error code 2200: BigQuery timeout after 5 min

Hi, Anonymous 

See if the following reasons fit your situation:

• When you create Excel dataset and import schema from connection/store, preview data, list, or refresh worksheets, you may hit timeout error if the excel file is large in size.

• When you use copy activity to copy data from large Excel file (>= 100 MB) into other data store, you may experience slow performance or OOM issue.

Resolution:

• For importing schema, you can generate a smaller sample file, which is a subset of original file, and choose "import schema from sample file" instead of "import schema from connection/store".

• For listing worksheet, in the worksheet dropdown, you can click "Edit" and input the sheet name/index instead.

• To copy large excel file (>100 MB) into other store, you can use Data Flow Excel source which sport streaming read and perform better.

You can learn more about it in this document: Troubleshoot copy activity performance - Azure Data Factory & Azure Synapse | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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