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
Community Champion
2 years ago

Not talking about the configuration... The configuration has been done in the VM I beleive. But you found out that the refresh is not working then you wanted to fix it out side the VM, is it not?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

No I didn't try to fix it outside of the VM. The VM is not in Azure by the way.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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
    Community Champion
    2 years ago

    Did you try to refresh the report in the desktop? if not then please do and then republish it, maybe the fact that you updated the Gateway has something to do with it.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, just to verify that it wasn't the ODBC that is the problem. It's probably a Microsoft related issue itself. Who knows.

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    I had the feeling that something needed to done at the server level, like maybe updating the ODBC.. But glad you fixed it

     

    You are welcome.