Forum Discussion
Error trying to refresh a dataset
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
2 Replies
1. Is this Azure SQL DB - > Yes - > Then allowed your IP in the firewall settings in Azure.
docs.microsoft.com firewall-configure2. 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!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.
