error message when refreshing the dataset in power bi desktop

[Nepal101]

Hello Everyone, 
Can you please provide any suggestions on how I can resolve this issue? been stuck on this 😞

[Nepal101]

Hello @Len_Barr thank you for the reply. 
I happened to contact him and they said all the connection is correct and there isn't anything that has changed. 
I tried to load the data by adding the SQL query and it loaded. But when I tried to merge the tables with another table that is already loaded in Power bi then it shows an error. 

[Len_Barr]

Looks like your connection to the dataset was closed from the host end. 

Check to see if there has been a login change of some sort or administration changes in your database. Better still, if you have a database administrator in your company, contact them.