Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Nandu2520
Helper I
Helper I

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 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 :

 

Nandu2520_0-1671079652895.png

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.

 

 

1 ACCEPTED 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.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.