Forum Discussion
Solved
Connecting Power BI with an Azure SQL Server Database using direct query
I am currently trying to connect an Azure SQL Server Database to Power BI using direct query. I have put in the correct server name and I am using direct query. it is not connecti...
Hi Monika,
I know it's not exactly the same thing, but I just created a new Azure DB in my tenant and could connect ok.
Double check you have the correct credentials (are you using a Windows or Database username/login)
Do you know if Azure has been configured to allow your client to connect via the firewall?
Other than that. my server was something.database.windows.net rather than a microsoft.com address.
If you'd like to pm me screenshots of the connection screens I may be able to help more.
Its just interesting that the error is suggesting it thinks the name of the server is just Microsoft.com
It is coming from my oragnaization id.