Forum Discussion

Pyelamanchili's avatar
Pyelamanchili
Frequent Visitor
5 months ago
Solved

Power BI Server Refresh issues

Hello All,   I have a Power BI Report that conneccts to Snowflake through KeyPair. It refreshes in my desktop without any errors. However on the server it runs through gateway, and failes to refre...
  • Pyelamanchili's avatar
    Pyelamanchili
    4 months ago

    Hello,

    Sorry for the delayed response.  I have tried these but nothing worked. 

    But while digging through, I understand the issue is with the Keypair Update on snowflake account.

     

    For Power BI (Desktop, cloud, gateway) Snowflake Account has to be TYPE= PERSONAL. 

    Snowflake account TYPE = LEGACY_SERVICE /SERVICE is not supported for KeyPair Authentication.

     

    My snowflake was set to LEGACY_SERVICE, whick is a potential reason for the failures.

     

     

    Additional documentation: Partner support for Snowflake authentication methods | Snowflake Documentation