Forum Discussion

S_Grasberger's avatar
S_Grasberger
Regular Visitor
5 months ago
Solved

Snowflake keypair authentification: Internal error Can't convert 12 to proper M credential Type

Hi all, 

we are currently working on changing the snowflake authentification method from basic auth to keypair. 

When we create a new dataflow (Gen1) using keypair everything works fine and the dataflow can be refreshed without any issues. 

If we try to modify an already existing Dataflow the connection works too, the data can be refreshed within power query but if we try to refresh the whole dataflow we get this error message : Error: Internal error Can't convert 12 to proper M credential Type

Does anyone have the same problem and know how to fix it?

 

Thank you in advance 

BR Simone 

  • Hi S_Grasberger ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    In Fabric, go to Data Factory --> Dataflows Gen2 and create a new Snowflake connection with Key Pair. Recreate your queries in the new Gen2 dataflow and validate refresh.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

8 Replies

  • JillianHay's avatar
    JillianHay
    Frequent Visitor

    Hi
    I've got the same problem, except I am creating a gen 1 dataflow from scratch (no gateway). I've tried completely deleting everything snowflake related (gateway connection and the dataflows) and starting again and I still get the same error. The microsoft page I had open is now giving a gateway error, so I'm not sure what's going on with it - https://blog.fabric.microsoft.com/en-nz/blog/snowflake-key-pair-authentication-generally-available?ft=09-2025:date


    If anyone manages to resolve this, I'd appreciate some help!

     

  • Hii S_Grasberger 

     

    Delete the existing Snowflake data source credentials from the dataflow settings (or Workspace >> Manage connections), then recreate the connection using Key Pair authentication. If the issue persists, recreate the dataflow with a fresh Snowflake connection, as modifying an existing auth type is not fully supported in Gen1.

  • Hi rohit1991 , thank you for your quick reply ! 

    Yesterday, I tested everything I could think of regarding connections, but without success.

    I think I really need to create all dataflows from scratch instead of changing them. 😕

    Thanks ! 

     

  • v-dineshya's avatar
    v-dineshya
    Community Support

    Hi S_Grasberger ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    In Fabric, go to Data Factory --> Dataflows Gen2 and create a new Snowflake connection with Key Pair. Recreate your queries in the new Gen2 dataflow and validate refresh.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

    • v-dineshya's avatar
      v-dineshya
      Community Support

      Hi S_Grasberger ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

       

      Regards,

      Dinesh

      • v-dineshya's avatar
        v-dineshya
        Community Support

        Hi @S_Grasberger ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

         

        Regards,

        Dinesh