Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
yt1987
New Member

Connecting Power BI with an Azure SQL Server Database

I am not able to connect to the Azure SQL Database to Power BI. Below points has already been checked.

  • correct server name
  • SSMS installed on the same machine that has Power BI Desktop installed.
  • a firewall rule is setup to allow Power BI Desktop to make a connection to Azure SQL.

Below error is reported:

 

Unable to Connect

We encountered an error while trying to connect

 

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server.)"

2 REPLIES 2
Anonymous
Not applicable

@yt1987,

I can successfully connect to Azure SQL database in March update of Power BI Desktop. what version of Power BI Desktop do you use? Are you able to connect to the database in SSMS?

In your scenario, please clear cache in Power BI Desktop, clear permissions for the existing Azure SQL connections in your PBIX file , then check if you can connect to the database.
1.JPG2.JPG

Regards,

Lydia

yt1987
New Member

I am trying to connect to Azure SQL database from my Power BI desktop, but I am not able to connect to the dabase. I have already checked into the below points.

  • SSMS is installed on the same machine that has Power BI Desktop installed.
  • a firewall rule has already been to allow Power BI Desktop to make a connection to Azure SQL.
  • correct server name

 

Below error is reported:

Unable to connect 

 

We encountered an error while trying to connect

 

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server.)"

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.