Forum Discussion

MB_A's avatar
MB_A
New Member
1 month ago
Solved

Power BI Desktop - Snowflake connector

Hi everyone, I'm looking to understand whether anyone has successfully implemented the following architecture. We'd like Power BI developers to authenticate to Snowflake from Power BI Desktop using...
Need Help
Show and Tell
  • v-csrikanth's avatar
    v-csrikanth
    1 month ago

    Hi MB_A 

    Thank you for reaching out.

    Import mode isn't the blocker. In Power BI Desktop, the Microsoft account (Microsoft Entra ID) option works for both Import and DirectQuery your own Entra identity is used at connect/refresh time. The DirectQuery-only guidance you found refers to per-user SSO in the Power BI service; Import models refresh with a single stored credential, so per-user SSO never applies there.

    Connector auth options: Snowflake (username/password), Microsoft account (Entra ID), Key Pair, Service Principal.

    Okta isn't one of them and note the Snowflake option is plain username/password, it does not redirect to Okta.

    Practical path: federate Okta to Entra ID, configure Snowflake External OAuth with external_oauth_type = azure, then use Microsoft account in Desktop. Worth validating in a non-production account first.

    References:

    Thanks,
    C Srikanth
    Community Support Team

     

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 month ago

Hi MB_A 

We would like to inquire whether have you got the chance to check the solutions provided by ShahRukhSameer  in community to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

 

Thank you,
C Srikanth
Community Support Team