Forum Discussion

Pyelamanchili's avatar
Pyelamanchili
Frequent Visitor
6 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...
Need Help
Tips and Tricks
  • Pyelamanchili's avatar
    Pyelamanchili
    5 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

     

Pyelamanchili's avatar
Pyelamanchili
Frequent Visitor
5 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

 

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

Hi Pyelamanchili 

Thank you for sharing the details. If you have any more questions, please let us know and we’ll be happy to help.

Regards,

Microsoft Fabric Community Support Team.