cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoseLuisAGZZ
Frequent Visitor

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

 

JoseLuisAGZZ_0-1627920543856.png

 

2 REPLIES 2
MrSujay
Resolver II
Resolver II

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
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!