Forum Discussion

dmontgom2000's avatar
dmontgom2000
Frequent Visitor
1 year ago
Solved

Snowflake ODBC Power BI Gateway

Hello  I am running into an issue I could use some advice on.  This is our scenario.  We are moving to Snowflake and currently have a bunch of Power BI reports.  We have found many use cases for Pag...
Need Help
  • andrewsommer's avatar
    andrewsommer
    1 year ago

    Definitely configure a System DSN rather than a User DSN on the Gateway. A System DSN is available for all users on the machine, which ensures that the Gateway service (which typically runs under a system account) can access the DSN.

    Also, check the Gateway service account permissions to ensure that it has access to the ODBC data source. If the Gateway is running under a different account than your local user account, there may be permission issues.

    You can test the connection directly on the gateway using Powershell, SQL workbench or ODBS Data Source Administrator

     

    Please mark this post as a solution if it helps you. Appreciate Kudos.

andrewsommer's avatar
andrewsommer
Super User
1 year ago

Definitely configure a System DSN rather than a User DSN on the Gateway. A System DSN is available for all users on the machine, which ensures that the Gateway service (which typically runs under a system account) can access the DSN.

Also, check the Gateway service account permissions to ensure that it has access to the ODBC data source. If the Gateway is running under a different account than your local user account, there may be permission issues.

You can test the connection directly on the gateway using Powershell, SQL workbench or ODBS Data Source Administrator

 

Please mark this post as a solution if it helps you. Appreciate Kudos.