I am trying to get data into Power BI by connecting to the Microsoft SQL Server of our company. But I am getting a message saying “We encountered an error while trying to connect. Microsoft Sql: Cannot open server xyzcompany.com requested by this login. The login failed”

I, however, am able to access SSMS using the same server name without any issues.

What shall I have to do to establish the connection?

Thanks

AR