Forum Discussion
Connecting Power BI with an Azure SQL Server Database using direct query
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.
Hi Monika
Are you just putting Microsoft.com in the servername, or is the servername much longer?
Cheers,
Phil
Thanks for reply Phil!!
Yes. Server name is too long. I am sure it is correct.
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.
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.