COPY INTO statement in Fabric fails with special character in external path

[Anonymous]

When trying to load external csv content from ADLSGen2 location into Fabric DataWarehouse table using COPY INTO statement, if the external path contains special chars (eg:  ~`), COPY INTO statement fails.

Example COPY INTO statement with special char:

COPY INTO "~`tgt~`schema3~`1699256789769"."striim_admin_T2_~tgt~table~"
 FROM 'https://infra760.blob.core.windows.net/striim-dwh-cntr/.striim/~`tgt~`schema3~`1699256789769.~tgt~table~0.csv.gz'
 WITH (
    FILE_TYPE = 'CSV',
    CREDENTIAL = ( 
        IDENTITY='Storage Account Key',
        SECRET='xxxxx'
    ),
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '0x0D0A'
 ) OPTION ( LABEL = 'COPY: "~`tgt~`schema3~`1699256789769"."striim_admin_T2_~tgt~table~"');

Error message:

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi - otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .