Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

Specify Database in Snowflake Connection in Power BI Service with VNET Gateway

Greetings.   We are using a VNET Gateway to connect to Snowflake from Power BI. We have a Snowflake Warehouse with multiple databases. However, there is no way to specify a database in the Snowfla...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    Hi Anonymous ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Hi tayloramy  and lbendlin , Thank you for your prompt response.

     

    Hi Anonymous , In addition to tayloramy  response, i have added some more points.


    Please try below options to Specify the Database in Power BI Service with VNET Gateway.

     

    1. You can configure default roles and databases for users in Snowflake to streamline access and reduce ambiguity.


    2. If you are using Microsoft Entra ID or Azure AD for SSO, check that the Snowflake user mappings and network policies are correctly configured.

     

    3. Check your VNET Gateway is properly configured and that the subnet delegation is set to Microsoft.PowerPlatform/vnetaccesslinks.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

lbendlin's avatar
lbendlin
Super User
10 months ago

The standard approach is to include the database name in the SQL query.