Synapse copy data from excel dataset error

Luka Ostojic 1 Reputation point
2022-05-20T14:04:36.73+00:00

Hi,

I have excel file that have graph which points to external link and because of that i get error when i try to preview or load data via Synapse from .xlsx file.
Is there a way to solve this without deleting graph manually?

204192-error-img.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,396 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,603 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,096 Reputation points
    2022-05-22T21:59:36.25+00:00

    Hi,

    Note! It is highly important to add errors as text and not only as images since we cannot parse the error or search it when using images.

    only '.xls' and '.xlsx' format is supported in reading excel file

    Try to get the data from source instead of from the excel.

    or you can try export your Excel data as text before you use Azure Data Factory to import it.