Forum Discussion

madadiva's avatar
madadiva
New Member
6 months ago
Solved

Snowflake semantic views (beta) connector

Hello all,

 

I am trying to use the new snowflake Semantic Views (beta) (custom) connector in powerBI. I am getting this error message. Did anyone had luck with it?. I used microsoft authentication to connect to the snowflake.

 

We encountered an error while trying to connect. Details: "ADBC: [Snowfalke]261004 (08004): failed to auth for unknown reason.

 

Thanks

Vinitha

 

Need Help
  • v-karpurapud's avatar
    v-karpurapud
    6 months ago

    Hi madadiva 


    Thank you for reaching out to the Microsoft Fabric community forum.


    The issue occurs due to the use of the new ADBC‑based Snowflake connector implementation, which is currently associated with authentication inconsistencies in certain scenarios.

    As a troubleshooting step, please try enabling “Use legacy Snowflake connector implementation” under:

    File → Options and settings → Options → Preview features.
     

     

    After enabling this option, restart Power BI Desktop and attempt the connection again.

    If the connection succeeds when using the legacy implementation, this would indicate that the issue is likely related to the newer ADBC‑based Snowflake connector implementation.

     

    Please note that the Snowflake Semantic Views connector depends on the new connector implementation and is therefore not expected to function in legacy mode. If Semantic Views are required and authentication continues to fail, further investigation may be needed into the Snowflake OAuth/SSO configuration, or the behavior may be attributable to the current preview status of the connector.
     

    Please let us know the outcome after testing.

     

    If you have any further questions, feel free to reach out and we'll be glad to assist.

     

    Regards,

    Microsoft Fabric Community Support Team.

3 Replies

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support
    6 months ago

    Hi madadiva 


    Thank you for reaching out to the Microsoft Fabric community forum.


    The issue occurs due to the use of the new ADBC‑based Snowflake connector implementation, which is currently associated with authentication inconsistencies in certain scenarios.

    As a troubleshooting step, please try enabling “Use legacy Snowflake connector implementation” under:

    File → Options and settings → Options → Preview features.
     

     

    After enabling this option, restart Power BI Desktop and attempt the connection again.

    If the connection succeeds when using the legacy implementation, this would indicate that the issue is likely related to the newer ADBC‑based Snowflake connector implementation.

     

    Please note that the Snowflake Semantic Views connector depends on the new connector implementation and is therefore not expected to function in legacy mode. If Semantic Views are required and authentication continues to fail, further investigation may be needed into the Snowflake OAuth/SSO configuration, or the behavior may be attributable to the current preview status of the connector.
     

    Please let us know the outcome after testing.

     

    If you have any further questions, feel free to reach out and we'll be glad to assist.

     

    Regards,

    Microsoft Fabric Community Support Team.

    • v-karpurapud's avatar
      v-karpurapud
      Icon for Community Support rankCommunity Support
      6 months ago

      Hi madadiva 

      I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

      Thank You.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    6 months ago

    Hi madadiva,

    Checking in to see if your issue has been resolved. let us know if you still need any assistance.

     

    Thank you.