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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.