Forum Discussion
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 ...
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
Community Champion
Community ChampionAre you using ODBC driver to connect to Excel files? Is the machine or the ODBC drive off line some how?
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.