Forum Discussion

manoj_0911's avatar
manoj_0911
Icon for Kudo Commander rankKudo Commander
6 months ago
Solved

integrating Power BI with Snowflake using OAuth authentication through Azure AD.

We are integrating Power BI with Snowflake using OAuth authentication through Azure AD.
Our dataset uses Import Mode and scheduled refresh in Power BI Service.

 

The OAuth login used is a Customer account mapped to a Snowflake service user.

I would like to confirm:

  1. Does Power BI Service maintain OAuth credentials for Snowflake refresh long-term, or is periodic reauthentication required?

  2. Is an on-premises data gateway required for Snowflake cloud connections when using OAuth?

  3. Are there recommended best practices for using service accounts versus personal accounts for dataset refresh?

Need Help
  • Anonymous's avatar
    Anonymous
    6 months ago

    Hi manoj_0911 ,
    Thank you  for reaching out to the Microsoft fabric community forum.

    When you connect Power BI to Snowflake using OAuth through Azure Active Directory, the login credentials are saved in the dataset settings in Power BI Service. Scheduled refresh will use those saved credentials. Normally you don’t need to sign in again unless the token expires or permissions change, in that case you may need to re-authenticate in the dataset credentials.

    Since Snowflake is a cloud source, an on-premises data gateway is not required. Power BI Service can connect to it directly.

    For refresh setup, it is usually better to use a service account instead of a personal account. This helps avoid refresh issues if the personal account access changes.

    Kindly refer to the below documentation links for better understanding:
    Connect to Snowflake with Power BI - Power BI | Microsoft Learn

    Hope this helps. Let us know if you need more details.
    Regards,
    Community Support Team.

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 months ago

    Hi manoj_0911 ,
    Thank you  for reaching out to the Microsoft fabric community forum.

    When you connect Power BI to Snowflake using OAuth through Azure Active Directory, the login credentials are saved in the dataset settings in Power BI Service. Scheduled refresh will use those saved credentials. Normally you don’t need to sign in again unless the token expires or permissions change, in that case you may need to re-authenticate in the dataset credentials.

    Since Snowflake is a cloud source, an on-premises data gateway is not required. Power BI Service can connect to it directly.

    For refresh setup, it is usually better to use a service account instead of a personal account. This helps avoid refresh issues if the personal account access changes.

    Kindly refer to the below documentation links for better understanding:
    Connect to Snowflake with Power BI - Power BI | Microsoft Learn

    Hope this helps. Let us know if you need more details.
    Regards,
    Community Support Team.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 months ago

      Hi manoj_0911,
      I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

      Regards,
      Community Support Team.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 months ago

        Hi manoj_0911,
        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


        Regards,
        Community Support Team.