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.

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