Share via

Excel for Mac - PowerQuery to SQL server using Windows account

Klemen Novak 0 Reputation points
2024-12-16T11:43:24.34+00:00

Hi.

I switched from Windows to MacOS recently and I discovered a big limitation with using Excel for Mac when trying to retrieve data from SQL server hosted on our premises. Apparently, there is no way to authenticate using Windows account, only Basic (username/password) or Organisational account. Both not working for us. I can get the data using "From SQL server ODBC) using NTLM authentication. But since all of my Excel's were created on Windows using PowerQuery and also other collegues are using that type of connection, it is impossible for me to use Excel as intended.

Currently, I'm using Excel for Mac 16.92 (latest version in Beta channel).

I'd like to understand, if there will be option for Excel for Mac to use Windows account authentication for PowerQuery someday or not? Is there any alternative already in place?

Thank you in advance.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,053 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,225 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
520 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 68,721 Reputation points
    2024-12-16T16:36:05.5833333+00:00

    The excel for Mac uses Kerberos instead of NTLM (which is discouraged For windows). If your mac is not part of the domain and using windows login, then you use the “ticket viewer” app to login. The login should be like youname@domainname.com (it really the realm, so you need .com or .net)

    once you login with ticket viewer, you just trusted connection string just like windows.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.