Forum Discussion

SainathKrothap's avatar
SainathKrothap
Frequent Visitor
1 month ago
Solved

Power bi Snowflake Error

Hi Team, I'm trying to connect Power BI and Snowflake, using the user with key pair option. I setup everything in Snowflake, created RSA public and private keys and assigned the public key to user.

In power BI, I tried to connect using KeyPair option: I pasted entire private key, but receiving the following error:

Can anyone please help me with this?

 

Thank you,

Sainath

7 Replies

  • It is only not working on Desktop, it is working correctly in Power BI service

    • R1k91's avatar
      R1k91
      Icon for Super User rankSuper User

      are you using ODBC or ADBC connector? I believe the key is "-" symbol.

      I faced this and blogged it here

       

      • SainathKrothap's avatar
        SainathKrothap
        Frequent Visitor

        Hi, its time sync issue in my system, my IT fixed and its working fine.

        Thanks,

        Sai

  • Hi SainathKrothap​ 

    From my understanding, when using the keypad in desktop you will need a username the. Keypair, encrypted message as well as a pass phrase in order for this to work successfully. If you can, make sure that you have got all of those when trying it from desktop.

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support

    Hi SainathKrothap​,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you GilbertQ​ for the prompt response.

    As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user for the issue worked? or let us know if you need any further assistance.

    Thanks and regards,
    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Icon for Community Support rankCommunity Support

      Hi SainathKrothap​,

      We wanted to kindly follow up to check if the response provided by the user for the issue worked? or let us know if you need any further assistance.

      Thanks and regards,
      Anjan Kumar Chippa

      • SainathKrothap's avatar
        SainathKrothap
        Frequent Visitor

        Hi v-achippa​ , 

        Hi, its time sync issue in my system, my IT fixed and its working fine.

        Thanks,

        Sai