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

The ODBC driver was to connect to what source?

Can you please screenshot the Gateway and connections in the service?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    aj1973Please see the screenshots below in the service, Excel files on the same Gateway all work. Can't access the machine at this moment to share gateway screenshot directly but the service says its online:

    • 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.