Forum Discussion

vijaycp2's avatar
vijaycp2
Icon for Helper I rankHelper I
1 year ago

Error while connecting to dtaa source

We are getting following error message. The connection from PowerBI desktop works fine however we can't connect to SQL server database from Power BI    We have defined data source connection ...
"Power BI Report Server "
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

You need a gateway to access that on-prem database.

vijaycp2's avatar
vijaycp2
Icon for Helper I rankHelper I
1 year ago

We do have gateway which connects to on-prem database. 

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    Please show the connections section.

    • vijaycp2's avatar
      vijaycp2
      Icon for Helper I rankHelper I
      1 year ago

       

    • vijaycp2's avatar
      vijaycp2
      Icon for Helper I rankHelper I
      1 year ago

      Worked with Microsoft technical support team and modified data gateway sqlsrvr.dll.config file. After dll.config changes started working. 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        1 year ago

        what did you change in that file?