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

     

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

Hi Pyelamanchili 


Thank you for contacting the Microsoft Fabric community forum.

 

The issue is linked to the gateway execution environment, not Snowflake permissions.When a dataset refresh occurs in Power BI Service, the gateway’s mashup engine executes queries, which is different from the local Desktop engine. Due to differences in runtime, drivers, and execution context, refresh results can vary between Desktop and Service. More details are available here:https://learn.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

 

While removing Implementation="2.0" may help in some Snowflake scenarios, it doesn't always impact how the gateway processes connections, so it did not resolve this issue. Please check the gateway setup to ensure it is correct. The on-premises data gateway should be up to date, and the Snowflake data source must be fully configured with all required settings like server, warehouse, and role. Mismatched or incomplete configurations can still cause refresh failures, even if Desktop works as expected:https://learn.microsoft.com/power-bi/connect-data/service-gateway-onprem

 

It’s also important to consider how the private key is accessed. The gateway operates under a Windows service account, so if the key is stored locally or in a restricted folder, it might not be accessible during refresh, even if it works in Power BI Desktop. Ensure the key is in PKCS#8 format, set up correctly in Power BI Service, and available to the gateway service account.
 

Finally, confirm that the Snowflake driver on the gateway machine is current and supported, as driver differences can affect refreshes.Power Query Snowflake connector - Power Query | Microsoft Learn
 

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

Regards,

Microsoft Fabric Community Support Team.