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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
vhmp_23
New Member

Power BI Access to SQL Failing on Windows 11 via Service Accounts

My service accounts does connect since my computer has been updated to Windows 11. I cannot connect via Power BI (Says credentials can not be authenticated) and I cannot connect via Microsoft SQL Server Management Studio (Says "Logon Failure: the user has not been granted the requested logon type at this computer"). I had zero issues ussing same credentials on windows 10 to connect

1 REPLY 1
Anonymous
Not applicable

Hi @vhmp_23 ,

Ensure that the account is a work or school account, as personal Microsoft accounts may experience login problems with Power BI Desktop. Running Power BI Desktop with elevated privileges may resolve connection issues, you can try running Power BI Desktop as Administrator.

 

Error messages in SSMS usually indicate problems with user rights assignments or group policy settings. Please check the user rights assignments to ensure that the account in question has the "Allow log on locally" and "Login as batch job" permissions.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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