Can't access fabric SQL endpoint from my computer - integreted securety not supported for one WS

[Thomas_R]

Hi

I have a problem, where I can't connect to one of our databses / SQL endpoinds in fabric for one workespace from my computer.

When I try another workspace from my computer - with the same access level, I can connect to that endpoint. And when I try to connect from a co-workers computer in Power BI, I can connect to the workspace and SQL endpoint to.

So the wiedr thing is, that it's only that one workspace, form my computer. I don't really get any error message other that this: "integreted securety not supported". But as stated, it does work in other workspaces from my computer.

Any ideas?

Info:

Version: Version: 2.124.1554.0 64-bit (December 2023)

Wondows 11

[bozkan]

Hi,

Switching the authentication method to a Microsoft Account instead of Windows authentication might resolve the issue.

[Anonymous]

Issue is coused by datmart URL change.

Some time ago Microsoft changed datamart SQL endpoint url

from xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.datamart.pbidedicated.windows.net

to:  xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.datamart.fabric.microsoft.com

when you change connetion string to datamart.fabric.microsoft.com issue will be solved. 

[Thomas_R]

I've tried the diffent sollutions, but it did not work. I also tryed it on a 3. computer, where it also did not work. 

[Anonymous]

Hi @Thomas_R ,

Based on the error message you provided, it seems like the issue might be related to integrated security. However, since you mentioned that you’re able to connect to the endpoint from another workspace and a co-worker’s computer, it’s possible that the issue is specific to your computer or network.

Here are some steps you can try to troubleshoot the issue:
1.Ensure that your computer's network configuration allows connections to the specific SQL endpoint's address and port (typically TCP 1433).
2.Verify that any firewall on your system or network is not blocking the connection to the Fabric SQL endpoint.
3.The "integrated security not supported" error typically indicates an issue with authentication. Since Fabric uses Microsoft Entra ID for authentication, make sure you're using correct credentials and authentication method.
4.If you're using a connection string, ensure it is formatted correctly and does not include or , as these are not supported by Fabric.

Integrated Security=True
Trusted_Connection=True

For more details on how to create a sql endpoint and use power bi to get data from workspace via sql endpoint you can refer to the official documentation.

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
CREATE ENDPOINT (Transact-SQL) - SQL Server | Microsoft Learn

Best regards

Albert He

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