Forum Discussion

rajaniesh's avatar
rajaniesh
Icon for Helper II rankHelper II
7 years ago

Power BI Gateway setup with ODBC connectivity throwing error

Hi,    I have successfully setup a PowerBI Gateway VM in onPremise environment and setup System DSN with ODBC connectivity to DB2. I have tested it and it is working fine when I connect PowerBI Des...
Need Help
Show and Tell
rajaniesh's avatar
rajaniesh
Icon for Helper II rankHelper II
7 years ago

How to debug this issue because I am able to connect to the Db2 by Powerbi Desktop but when I try to connect from PowerBI Gateway it throws the error I pasted.

 

Regards
Rajaniesh

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
7 years ago
Hi there

Can you confirm from your Power BI Administrator that you can install and configure data sources in the Gateway?
  • rajaniesh's avatar
    rajaniesh
    Icon for Helper II rankHelper II
    7 years ago

    Yes I can install the gateway and I have installed the Gateway and it is showing it online.

     

    Regards

    Rajaniesh 

    Blog

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      7 years ago

      Hi there

       

      Can you have a look at the logs when you try and create the connection and see what the error is?

       

      Also is the ODBC driver installed on the Gateway Server?

      • rajaniesh's avatar
        rajaniesh
        Icon for Helper II rankHelper II
        7 years ago

        Yes ODBC driver is installed and Power BI  Desktop is connecting by using ODBC driver.