Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Gateway Is Online But Cannot Connect To Data Sources

So this is a strange one. I have a gateway that refreshes reports that are based on excel sources and an ODBC connection. It used to run fine until day before yesterday. I thought it was because the ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    aj1973Apparently, the server machine needed to be restarted and updated which fixed the problem. I feel so dumb right now but thank you for being so helpful, you really added to my reportoire of troubleshooting.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Are you using ODBC driver to connect to Excel files? Is the machine or the ODBC drive off line some how?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

The machine with the ODBC drive is very much on. Every other software, including Power BI Desktop, connects to it just fine and refreshes or pulls data.

As for the Excel connections, I simply chose file as the connection type, provided the full path name to the file and used the Windows authentication method to log in.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    For sure the Gateway isn't the issue. Try privacy level = none

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Tried that level and every other level. Same result. That's why I'm pulling my hair out because nothing seems to work. The machine with the gateway is a virtual machine. Don't know if that matters.

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        2 years ago

        That's what it is then, VM. Yes it matters.

        Is this the first time you are trying to set up connection outside your network?