Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ODBC Gateway Setup fail!

Hi,  1) the base info : PBI - Pro, Gateway - On-premises 2) I learned about the community's thread on this issue https://community.powerbi.com/t5/Service/Can-t-connect-ODBC-datasource-to-gateway/m-...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    You need to successfully connect to your data source via ODBC on the gateway VM before you can proceed to create the connection on the gateway. The ODBC system dialog has a "Test" option. You can use that, or install a database client on the gateway VM for the test.

lbendlin's avatar
lbendlin
Super User
6 years ago

Can you connect via ODBC on the gateway?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    No , cannot , that's why I post this issue for help....!

     

    And.. I can connect data /and SQL data through ODBC to PBI desktop , it's successfully...

     

    JUST Gateway setup datasource for refresh fail...

    • lbendlin's avatar
      lbendlin
      Super User
      6 years ago

      You need to successfully connect to your data source via ODBC on the gateway VM before you can proceed to create the connection on the gateway. The ODBC system dialog has a "Test" option. You can use that, or install a database client on the gateway VM for the test.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi, got it and tks!

         

        And could you recommend a VM link or VM software name to me? which fit for WIN10 OS and Power BI Gateway...

         

        tks!