Error "Microsoft SQL: Integrated Security not supported."

[Anonymous]

I tried to connect to the SQL endpoint of a Fabric warehouse and get this error

I didn't put any connection details in, I actually want to use a service principle connection

This was working yesterday

[Phierru]

In Power Query Editor go to Home / Data Source Settings then at the bottom Edit Permissions...
Under Credentials / Edit... chose Microsoft account and sign in.

[math87698]

Hi @Anonymous 

I had the same issue, somehow my Credential type for this specific Workspace was set to "Windows" which apparently does not work. I had to change it to "Organizational Account"

Try:

Go to Transform Data > Data Soruce Settings, look for your Fabric connection. Use Edit Permissions in order to change the credential type to "Organizational Account".

Cheers,

Matthias

[Anonymous]

Hi @Anonymous 

It's quite puzzling when something that worked one day doesn't the next. The error regarding "Integrated Security not supported" typically arises when there's a mismatch in the authentication method expected by the SQL endpoint and the one being provided by your connection setup.

Given that you mentioned this setup was working yesterday, here are a few areas you can explore:

1. Service Principal Credentials: Ensure that the service principal's credentials have not expired or been changed. You can verify and manage your service principal credentials through the Azure portal. For a refresher on creating and managing service principals, please visit Create a service principal.

2. Permission Changes: Verify if there have been any changes to the permissions assigned to the service principal or within the Fabric warehouse that might affect access. Remember, for a service principal to connect, it must have the appropriate roles or permissions assigned. Visit Workspace roles and permissions.

3. Connectivity Method: Ensure that the connection string or method you're using is correctly configured for service principal authentication. This includes specifying the tenant ID, client ID, and client secret (or certificate) of the service principal. Please see Service principal support in Data Factory.

Could you please confirm if there have been any recent changes in your environment that might have affected this setup? If after checking these areas the issue persists, it might be helpful to know:

• Have there been any updates or changes to the Fabric warehouse configuration?
• Are other connections or services experiencing similar issues?

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!