Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 Power BI Desktop, I could connect to Database, but When I try to click on any table, it shows below SELECT Permission denied error. When I verified the grants on the new login user, I could see SELECT Grant is there on the tables from dbo.
Please find the screenshot below :
Any suggestions on this ? Is there any impact of Microsoft account login also with these permissions?
My microsoft account does not have azure portal access. Is that matter in this case?
Thanks.
Solved! Go to Solution.
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.
@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
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 ?
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |