Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

How can I connect Power Bi with Azure Sql Dataserver,by using AAD credentials,I have tried to connect but got the following error

"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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"

How can I resolve it? 

1 Answer

0 votes
by (22.5k points)
edited by
  • Setup Azure Directory Admin on Azure Sql 
  • For Azure Sql Add firewall rule
  • Get data from Azure Sql Database 
  • And enter server name and database name
  • Sign with Azure credentials and then connect
  • Select get data

Want to learn more about Power Bi, Refer & learn Power bi   

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI

Thinking of learning Power BI? Here is the opportunity provided by Intellipaat to earn a certification in Power BI Course!

Related questions

0 votes
1 answer
0 votes
1 answer
asked Apr 5, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...