Refreshing data in Desktop timing out

Hello all,

While I don't know WHY I lost connection, I did figure out that by making a minor change to my sql query reestablished my connection and I was able to refresh the desktop file.

I have six data connections in this report, 3 are direct to tables on our Server and 3 are sql queries.

The first time this happened (on my original post), I removed the "order by" portion of my query and all was fine. I assumed the order by was causing too much processing time and that must have been it.

However, this happened again a few days ago, where all of the sudden, my refresh was failing with a "timeout expired" error.

I verified there is data in the tables on the server, and I tested each of my sql queries in MS SQL and they ran quickly, so it was for sure a connection issue between our server and PowerBI Desktop.

I tried making another minor change to the syntax, this time removing Distinct (making sure my row count did not change) and voila, the connection was reestablished. I went back in and added Distinct BACK in and it updated just fine, so it had nothing to do with the actual Distinct in my syntax. 

I belive somehow my connection between PowerBI and our database server broke and I needed to reestablish it. I have no idea why the connection broke, which is the next step in this mystery. 

One additional quesiton for the group. Is there another way to reestablish the connection between the SQL server and PowerBI outside of making changes to the actual query? I want to be sure I'm handling this using a best practice.

Thanks!