Forum Discussion

AJAJ's avatar
AJAJ
Helper IV
7 months ago

Same SQL Source table - ADF Copy Activity Succeeds but Fabric Copy Activity Fails- Auto create table

Hi there,   I'm using dynamic query to loop thru processing multiple tables. Source is SQL Server. Same table / Same query / Same SQL Source - Older ADF copy activity runs successfully. Fabri...
Need Help
pipelines
tayloramy's avatar
tayloramy
Super User
6 months ago

Hi AJAJ, 

 

I recommend you open a ticket with Microsoft. 

Automatic mapping tools have come a long way, but they are not 100% reliable yet.  

 

What you can do is in the source query, you can write a select statement that will cast the columns to a larger datatype, and then the copy data activity mapping will pick it up. 

 

 

  • AJAJ's avatar
    AJAJ
    Helper IV
    6 months ago

    tayloramy Thanks. Is this a paid support? Is there a microsoft bug reporting place where we can share any specific GUIDs that they can trace and fix. 

    • v-prasare's avatar
      v-prasare
      Community Support
      6 months ago

      Hi AJAJ,

      No this is not paid support though you need a powerbi subscription to raise support ticket and do include more information like failure details like error message, activity Id, capacity and other detail necessary to track and provide resolution to your case

       

       

      Thanks,

      Prashanth 

      MS Fabric community support

       

       

       

      • AJAJ's avatar
        AJAJ
        Helper IV
        6 months ago

        Thanks v-prasare . How to proceed here. We do have pbi pro across the company but this is fabric trial within that pbi pro.