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...
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!