title: Certain Azure SQL logins do not work with Power BI Desktop, but others do
body: <p>I have an Azure SQL database, with 3 main login accounts (users). one is my administrator account, with full rights, and the other two are one db_reader and one db_writer login. All three accounts can be used to log in to the database with SQL Server Management Studio. However, when I try to use these with Power BI Desktop, only the administrator login can connect to the database. Using the others, I get the error "Could not authenticate with the credentials provided". </p>
  
  <p>I am using the same machine as I am for SSMS, and I can log in with some accounts on this machine but not with other accounts on the same machine (i.e. it's not an IP/Firewall issue I think). </p>
  
  <p>Why can I not connect Power BI to Azure SQL using perfectly valid user logins? What makes this even more bizarre is that both of these logins work perfectly when I use them as the credentials for a Power BI Service Gateway, <em>to the same database</em>.</p>
  
  <p>Other users have the exact same issue on other machines; there is something wrong with these user accounts, but I don't know what it is, and it's definitely not that the credentials aren't valid. </p>
  
  <p>I would appreciate any help here!</p>