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

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 months ago

Temporarily install Power BI Desktop on one of your gateway VMs (don't forget to remove it afterwards) .  Then try to connect to your data source from that Power BI Desktop. See if you get an error message.

  • Pyelamanchili's avatar
    Pyelamanchili
    Frequent Visitor
    6 months ago

    Thanks for the response. MY gateway is set up by the Admin team. However, most cases you can change the ADBC to ODBC by removing Implemantation 2.0 from you MQuery!

    However that did not work for me. Trying the other ways