Forum Discussion

Nandu2520's avatar
Nandu2520
Icon for Helper I rankHelper I
3 years ago
Solved

SELECT Permission denied error from Power BI Desktop while connecting to Azure SQL Database

Dear All,   I was trying to connect to the Azure SQL database from Power BI Desktop. My DBA has created a new login user in the Database to access the Database from Power BI. When I was trying from...
Need Help
  • Nandu2520's avatar
    Nandu2520
    3 years ago

    I could connect, execute and load the data now. The issue is in the connection details/setting, the encryption check box is getting selected automatically. I have to unselect that check box and then try connecting again. Then its working. Thanks.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Nandu2520 , Install SSMS to the same machine and try to connect with the same user. It may be ip whitelisting issue.

Make sure IP is allowed and user have privileges

  • Nandu2520's avatar
    Nandu2520
    Icon for Helper I rankHelper I
    3 years ago

    Yeah, I have already installed SSMS and tried connecting with the user. I could connect and I could execute queries on the same tables. Only Power BI Desktop is giving the issue. Do we need to give any specific permissions to access from Power BI Desktop ?

    • Nandu2520's avatar
      Nandu2520
      Icon for Helper I rankHelper I
      3 years ago

      I could connect, execute and load the data now. The issue is in the connection details/setting, the encryption check box is getting selected automatically. I have to unselect that check box and then try connecting again. Then its working. Thanks.