Error trying to refresh a dataset

[JoseLuisAGZZ]

Hi yall!

Im facing this error while trying to refresh all my datasets, everything was okay last friday but when I came to the office today and tried to review some reports this error appears

anyone have an idea why is this happening?

thanks in advance!

best regards

[MrSujay]

1. Is this Azure SQL DB - > Yes - > Then allowed your IP in the firewall settings in Azure.
docs.microsoft.com firewall-configure 

2. Check your SQL port is changed or Not.
  more info - SQL-Connection-error-Named-Pipes/m-p/29203 
https://community.powerbi.com/t5/Desktop/Can-t-connect-to-SQL-Server-named-instance/m-p/308006

3. Check you have SQL server access in SSMS or not?

4. Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

@JoseLuisAGZZ Are you using an on-premises data gateway? If so, seems like it is having problems resolving the host name of your SQL Server.